Gates Is Antichrist
Well-known Member
- Joined
- Aug 15, 2002
- Messages
- 1,961
Puzzler...I have a range MyRange on Sheet2. I copied Sheet2 (alt-e-m) as Sheet1, so there's a local Myrange there now.
If I look at the refers-to with control-F3 while on sheet1, it refers to Sheet1, and you can see that it's local.
If I look at the refers-to with control-F3 while on sheet2, it refers to Sheet2, and you can see that it's NOT local. So far all cool.
Now in the VBA, ?Names(myRange).RefersTo
refers to sheet1 - EVEN WHEN Sheet2 is active.
Why in the heck would it do that?
If I look at the refers-to with control-F3 while on sheet1, it refers to Sheet1, and you can see that it's local.
If I look at the refers-to with control-F3 while on sheet2, it refers to Sheet2, and you can see that it's NOT local. So far all cool.
Now in the VBA, ?Names(myRange).RefersTo
refers to sheet1 - EVEN WHEN Sheet2 is active.
Why in the heck would it do that?