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.