Given a sub such as:
Private Sub Worksheet_Change(ByVal Target As Range)

If I type in something like:
Target.
into the VBE, I get that neat little popup window that gives me all the
properties, such as:
Name
giving us:
Target.Name
which I can select.

And so, I select Name, hit the tab key, and put a period after it. So
why now does the little popup window of I guess I should call them
"sub-properties" not show up this time when it did before? ONLY by
examining the locals window did I figure out that:
Target.Name.Name
would give me the name I assigned to that cell, as opposed to the value
(And what the heck is value2???). I now am wondering how many useless
motions and rediculously combined statements have I employed when I
could have used these drilled down properties to immediately identify
items to be examined for change. Is this a fault of my
system/installation or is it a universal problem?


--
brucemc
------------------------------------------------------------------------
brucemc's Profile: http://www.excelforum.com/member.php...o&userid=32871
View this thread: http://www.excelforum.com/showthread...hreadid=546085