I just use the CTRL-H search/replace function for this kind of thing.

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"David" wrote:

I have two issues both similar:

1) I have a number of columns, one of which has a formula with a Sheet!Cell
reference in the formula. I want to change the Sheet reference to another
sheet and previous the rest of the formula in that column. For example:

Old Sheet Name: DoThis
New Sheet Name: GoHere

--- Can some loop be constructed using For Each in maybe a VB module which
would do this? If so what is the object name and how would I do it?

---- Is there an easier way?

================

2) Basically the same issue, except the link is in another workbook.
I want to remove the linked workbook and move the single sheet on the
Workbook to another Workbook with multiple sheets?