IntelliSense Doesn't Assist with All Objects

Hi,

When I type "Range." IntelliSense will bring up the list of possible properties/actions. However, whenever I type anything referencing sheets or the workbook, i.e. "ActiveSheet.", it does nothing. I've gone to Tools>Options and I can't find anything on IntelliSense, but all of the options are turned on. I tried using the help function but it just gave me the legal jargon about how IntelliSense is theirs. Any help?

Application: Microsoft Office Excel, 2007, Visual Basic Editor.


Thanks in advance!

Use the actual object name or set a worksheet object reference.

Please Login or Register  to view this content.

Thanks for the name correction on what it's called.

I was hoping to fix it since it used to work. Not exactly a fan of leaving a part broken. Most of my sheets are declared as objects, but this part involves reviewing data to determine if the data needs to be modified for pivot tables, which first copies said sheet and then modifies copy. I'm trying to minimize my objects since I'm at ~50... working on reducing it >.> Is there a possible cause or reason why "ActiveSheet" stopped auto listing members?