Dé Céadaoin, 27 2019 Samhain
  0 Freagraí
  Cuairteanna 3.3K
0
Vótaí
Undo
I found the below VBA on this site.    How would I cause it to only find exact cell contents and then replace those contents?
Go raibh maith agat
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

Next

Application.ScreenUpdating = 
True

End
Sub
Níl aon fhreagraí déanta don phost seo go fóill.