What you observe is correct. Activesheet is ambiguous - like selection. To
illustrate from the immediate window:

? typename(Activesheet)
Worksheet
? typename(Activesheet)
Chart

The feature you speak of does not try to resolve the object within the
current context.

--
Regards,
Tom Ogilvy


"James C." wrote:

Hello,

I am trying to use the following bit of code and I am having trouble. I
believe I am missing a reference in the tools menu because when I type
ActiveSheet. nothing appears afterwards. If I had the right library loaded
then it should appear. Does anyone have any ideas of how I can find out which
library to use?

ActiveSheet.PivotTables("FocusMktList").RefreshTab le

These are the libraries that I have loaded
- Visual Basic For Applications
- Microsoft Excel 9.0
- OLE Automation
- Mcirosoft Office 9.0
- Microsoft Forms 2.0 Library