Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Macro in Excel 2002
I'm trying to create a macro that will create a Pivot
Table. I'm using the "record" function to record my steps as I create the Pivot Table. When I try to run the macro, I get an error: Run-time error '1004': AddFields method of PivotTable class failed. Here's the line in the macro code that fails: ActiveSheet.PivotTables("PivotTable1").AddFields RowFields:=Array( _ "Brand Code", "Iams Item Code", "Description"), ColumnFields:="Date" Any ideas on what I'm doing wrong? Thanks, Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: Can I sort columns of the Pivot Table ? | Excel Discussion (Misc queries) | |||
Excel 2002 - Pivot Table : Can I divide instead of sum ? | Excel Discussion (Misc queries) | |||
Excel 2002 Pivot Table Date | Excel Worksheet Functions | |||
Excel 2002 Pivot Table Protection | Excel Discussion (Misc queries) | |||
Pivot Table in Excel 2002 | Excel Discussion (Misc queries) |