Find and Replace in a Specific Range of Worksheets

[Toonloon]

Hi All,

I've tried numerous ways and can't seem to manage this......

I have 60 worksheets in my file - 52 of which are named 01,02,03, etc...through to 52

What I want to do is to is to search through the worksheets named 01 to 52 ONLY and do a Find and Replace.

I only want it to search these worksheets and ignore the other 8 sheets.

Does anyone know how this can be done... ?

 

[villy]

you can use vlookup or index, match to search for each sheets