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?