Where the address property of objects

[John T Ingato]

Dim MR as Range

Set MR = Range("A1:A12")
**************************

If I enter a watch "MR", I get the name "MR" with a plus sign
If I enter a watch "MR.Address", I get the range

When I peruse the plus sign in the "MR" watch window, there is not a
property called "address".

Where is it. Is it buried within another property, and if so... why can I
address it directly.

 

[Dick Kusleika]

John

The Address property isn't included in the watch window. Nobody knows why.
I think it was just a mistake in the program that never got fixed.

 

[Dana DeLouis]

In Excel XP, "value" is another item that is missing from the watch list. I
believe it was there in previous versions. ??

 

[Dick Kusleika]

Dana

Yep. It's in 2000. I wonder what kind of pot luck is in the XL2003.