Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
refering to Pivot Tables
If cell A3 is part of a pivot table, is it possible to
reference the table without knowing the name or index? If not, how do I obtain the name or index of a table if I only know it's location on a sheet? I can set the name for a table: ActiveSheet.PivotTables("PivotTable2").Name = "MyPivotTable" But I don't know or have control over the existing name (in this case, PivotTable2). It appears that the default name of the table is a sequential number based on the number of tables created in the same Excel session. Thanks in advance for any assistance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refering to multiple tables | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
OFFSET() not working within a SUMPRODUCT() when refering to a range in a pivot table | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Pivot tables-controlling user interaction with pivot tables | Excel Programming |