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.
So I recorded a macro replacing the Book1 name in the formula with Book2Please Login or Register to view this content.
When I record it, it is successful, but when it is rerun it does nothing to the formulas.
How can I correct the formulas from a linked workbook to look to a worksheet it’s own workbook?Please Login or Register to view this content.
Bookmarks