Question Locked

Excel VBA copy formulas to new Workbook without links

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When copying a worksheet to another workbook, the range names append the fullname (link) of the source worksheet into the RefersTo property. Any way to prevent this append of the fullname vs. changing it using for each aname in Names, or am I stuck having to load the RefersTo property to an array to revert the information to it's original state?

1 reply

This discussion is closed to new replies.