1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
Sub MultiFindNReplace()
'Update 20140722
' https://www.extendoffice.com/documents/excel/1873-excel-find-and-replace-multiple-values-at-once.html
Dim Rng As Range
Dim InputRng As Range, ReplaceRng As Range
xTitleId = "KutoolsforExcel"
Set InputRng = Application.Selection
Set InputRng = Application.InputBox("Original Range ", xTitleId, InputRng.Address, Type:=8)
Set ReplaceRng = Application.InputBox("Replace Range :", xTitleId, Type:=8)
Application.ScreenUpdating = False
For Each Rng In ReplaceRng.Columns(1).Cells
InputRng.Replace what:=Rng.Value, replacement:=Rng.Offset(0, 1).Value
Next
Application.ScreenUpdating = True
End Sub |
Partager