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?
