Not sure I understand. I have this type of code throughtout my module. I have
never had any problems running it until just recently. I ran this on a newer
version of excel, the module crashed and gives me the following error.

"Unable to get the PivotTables property of the Worksheet class"

I get this on everysingle one of my ActiveSheet...... lines?

Any ideas.



"Tom Ogilvy" wrote:

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