Sreda, 27 november 2019
  0 odgovori
  3.3 tisoč obiskov
0
Glasov
Razveljavi
Na tem mestu sem našel spodnji VBA. Kako naj povzročim, da najde samo natančno vsebino celice in nato zamenja to vsebino?
Hvala
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
Za to objavo še ni odgovorov.