i have the following code in vba:
Columns("C:C").Select
Selection.Replace What:="/", Replacement:=".", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
after my procedure runs i get a message box with an exlcamation point saying that it couldn't find anything to replace.
how do i supress this?
thanks
Lino
Columns("C:C").Select
Selection.Replace What:="/", Replacement:=".", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
after my procedure runs i get a message box with an exlcamation point saying that it couldn't find anything to replace.
how do i supress this?
thanks
Lino