You don't get Intellisense support because ActiveSheet isn't
always a worksheet. It might be a chart sheet.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"James C." wrote in message
...
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