Can you code a macro so it runs multiple times in the same workboo
 

I need a macro that finds and replaces to repeat once it is run within the
same workbook, until it has found and replaced everything.

Can you code a macro so it runs multiple times in the same workboo
 

Why would you need to run it multiple times?


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"dpmac" wrote in message
...
I need a macro that finds and replaces to repeat once it is run within the
same workbook, until it has found and replaced everything.

Can you code a macro so it runs multiple times in the same workboo
 

Take a look at Find and FindNext methods in VBA help, or even the Replace
method.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dpmac" wrote in message
...
I need a macro that finds and replaces to repeat once it is run within the
same workbook, until it has found and replaced everything.