| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveSheet & Apropriate Reference
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| activesheet | Excel Programming | |||
| Get ActiveSheet name in VB | Excel Programming | |||
| name of the activesheet | Excel Programming | |||
| ActiveSheet.Name? | Excel Programming | |||
| ActiveSheet | Excel Programming | |||
Threaded Mode
