G
Guest
why don't you simply use the Find/Replace method straight from the Edit menu
item?
Use a macro recorder to view the code thus generated. It'll give you pretty
all you need.
Here is the macro I just recorded, called macro1 and below my edited and
renamed procedure
Sub macro1()
'
' RepaceWith Macro
' Macro recorded 04/05/2005 by pmolloy
'
'
Columns("H:I").Select
Selection.Replace What:="what", Replacement:="with this", LookAt:=xlPart _
, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
Sub RepaceWith()
Columns("H:I").Replace What:="what", Replacement:="with this"
End Sub
item?
Use a macro recorder to view the code thus generated. It'll give you pretty
all you need.
Here is the macro I just recorded, called macro1 and below my edited and
renamed procedure
Sub macro1()
'
' RepaceWith Macro
' Macro recorded 04/05/2005 by pmolloy
'
'
Columns("H:I").Select
Selection.Replace What:="what", Replacement:="with this", LookAt:=xlPart _
, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
Sub RepaceWith()
Columns("H:I").Replace What:="what", Replacement:="with this"
End Sub