Where the address property of objects

  • Thread starter Thread starter John T Ingato
  • Start date Start date
J

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.
 
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.
 
In Excel XP, "value" is another item that is missing from the watch list. I
believe it was there in previous versions. ??
 
Back
Top