Excel VBA copy formulas to new Workbook without links

By rgExcelHelp ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums