Breaking a reference, keeping the value
Posted by Alex Vincent on October 26, 1999 12:56 AM
OK, this should be fairly easy -- from what I can gather, it's based on simple coding, I just don't know how to do it yet. (I'm familiar with the older members of the BASIC language family, but I've never worked with VBA before last week...)
I have a number of references to outside worksheets, sheets which are contained in other files. I want to break those references without losing the values contained in those files.
I noticed a link to a Microsoft add-in on this site, but I couldn't reach it, so I don't know if it is the solution to my problem.
In any case, I figured out how to do it for one cell:
Now, how do I extend that to a range of cells?