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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
news:[email protected]...
> 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.