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.