Ref:
Is there any intervening code between the selection of the sheets an
the
running of the replace command. It sounds like you select sheet Jan s
only
one sheet is selected.
I don't think so. The code above selects the required workbook and the
supposedly selects the required worksheets and then find/replaces wher
necessary.
...your code will not work
as you expect. The workaround is to loop through the sheets and perfor
the replace on each sheet.
I was afraid of that :(
It means turning 3 lines of code into 50 odd.
There are 3 incidences so that's an extra 140 lines of code :(
Oh well, what can't be changed must be endured
Cheers guys
--
Damin
-----------------------------------------------------------------------
Daminc's Profile:
http://www.excelforum.com/member.php...fo&userid=2707
View this thread:
http://www.excelforum.com/showthread.php?threadid=51056