I am using Excel ver 11 by the way
-----Original Message-----
Hi all,
If I record a macro that does a find / replace on a
sheet
and then record another one that does a Find / Replace
on
the entire workbook, they are identical!!
How can I code a Find / Replace statement that will
always perform on all sheets in my workbook?
e.g.
This is the one for the sheet:
Application.FindFormat.Clear
Application.ReplaceFormat.Clear
Cells.Replace What:="aaaa", Replacement:="bbbbb",
LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False,
SearchFormat:=False, _
ReplaceFormat:=False
..... and this is the one for the workbook:
Application.FindFormat.Clear
Application.ReplaceFormat.Clear
Cells.Replace What:="aaaa", Replacement:="bbbbb",
LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False,
SearchFormat:=False, _
ReplaceFormat:=False
The only way I can make it work, is to set the switch in
the Find / Replace Dialog box on the EDIT Menu bar.
Anyone know how to switch that on in the macro??
Thanks for any help ...
Best regards,
Robert
.
|