correcting "Linked" formulas after copying sheets to another workbook

I have a macro that copies 3 sheets from Book1 to Book2
Sheet 3 has formulas linking to Sheet1

In the newly copied Book2 Sheet3 the formulas maintain the link to Book1
I need to redirect them to the new Book2 in which they reside.

So I recorded a macro replacing the Book1 name in the formula with nothing
When I record it, it is successful, but when it is rerun it does nothing to the formulas.

Please Login or Register  to view this content.

So I recorded a macro replacing the Book1 name in the formula with Book2
When I record it, it is successful, but when it is rerun it does nothing to the formulas.

Please Login or Register  to view this content.

How can I correct the formulas from a linked workbook to look to a worksheet it’s own workbook?

That doesn't do it either

(probably should have mentioned that the preceeding line is

Please Login or Register  to view this content.

there are only formulas in Columns B & C

This works for me.

Are the worksheet and workbook specified in the code?
If not, is the macro being run from the workbook you want it to operate on?

I'm using XL2000 now but it failed to replace at home last night in XL2007 also.

I believe they are specified.
It was NOT in the workbook it was being performed on but I put it there to test and it still failed.

the entire section of code is

Please Login or Register  to view this content.

PS. everything else works fine except the replace command