find and replace multiple values in excel , find and replace in excel vba , excel, Microsoft excel,

preview_player
Показать описание
Find and Replace Multiple Values, find and replace multiple values in excel, find and replace in excel vba,

vba code
///////////////////////////////////
Sub MultiFindNReplace()
'Update 20140722
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, Lookat:=xlWhole
Next
Application.ScreenUpdating = True
End Sub
/////////////////////////////////////////////////////

excel, Microsoft excel,
find and replace multiple values in excel,
find and replace in excel vba,
find and replace formula in excel,
find and replace in excel multiple items,
HOW TO find and replace in excel multiple items,
find,
replace
Рекомендации по теме
Комментарии
Автор

Great sir...
Sir..how to fix range in one time..
And then only change original range valu...

fhussainmomin
Автор

Sir agar same column ki value na change krk..1 column ka vlookup references lekar usk 2, 3 etc column ka value change karna hai to kaise hoga...

Thanks in advance

sandyshrm
Автор

HI SIR THANK YOU FOR THIS VALUABLE INFORMATION... BUT IT CHANGED EACH CELL VALUE IN THE ENTIRE WORK BOOK AND I NEED TO CHANGE ON ONLY ONE PARTICULAR SHEET. PLZ HELP

SagarSharma-mehn
Автор

Sir replace range ka data formula mei hi set kaise hoga

marutnandan
Автор

When I press F5, by keyboard lights are turning on. What to do? Please help!

elakeyaudhaya
Автор

Sir replace ke waqt color fill kaise karenge

saching