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

[dpmac]

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.

[Peo Sjoblom]

Why would you need to run it multiple times?


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"dpmac" <dpmac@discussions.microsoft.com> wrote in message
news:EAF5464A-F4D2-4A15-AD14-BF28EDDF3E78@microsoft.com...
>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.

[Bob Phillips]

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" <dpmac@discussions.microsoft.com> wrote in message
news:EAF5464A-F4D2-4A15-AD14-BF28EDDF3E78@microsoft.com...
> 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.