One workbook or many. If the former, try Find/Replace (Ctrl-H)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jon" wrote in message
...
All,
I made a small mistake in one line of code of which there are a trillion
copies. Basically, I want to write code to find and replace lines in the
sheet modules.

ex. The sheet module has a line of code
Call JonMessedUp

I want to find all instances of that line in all the sheet modules and
change them to
Call JonDidNotMessUp

That's it.
Thanks in advance!!

--
J