Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Does anyone know where examples can be found of creating pivot tables
in macros? After some reading up on pivot tables, I went through the steps to create one that I needed and recorded the steps in a macro. But when I tried to run the macro, it failed on a line with the following in it: ....ActiveSheet.PivotTables("PivotTable13"). ... Presumably, the problem is with the pivot table name. I'm looking for some examples that show how to name a pivot table so I can have the same name each time, as well as examples that show how to deal with other pitfalls. Thanks. - Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating Views within pivot tables | Excel Discussion (Misc queries) | |||
creating a pivot table from 4 pivot tables | Excel Worksheet Functions | |||
Creating Pivot Tables | Excel Discussion (Misc queries) | |||
Creating Pivot Tables using a CSV file | Excel Discussion (Misc queries) | |||
Creating multiple pivot tables from same cache | Excel Programming |