| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign a macro to create a pivot table
I am currently creating a macro from a data worksheet but I am receiving an error. :( Initially, I just recorded the macro however when I am running it, i am receiving an addfields method of Pivot Table Class failed. ActiveSheet.PivotTables("PivotTable4").AddFields RowFields:="Level 3", _ ColumnFields:="Date" this is code that was having an error and I am not sure what was wrong with it? Can someone forward me a sample of the macro code to resolve this? Alib -- acsugguiyao ------------------------------------------------------------------------ acsugguiyao's Profile: http://www.excelforum.com/member.php...o&userid=24519 View this thread: http://www.excelforum.com/showthread...hreadid=381168 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Record Macro to Create Pivot Table | Excel Discussion (Misc queries) | |||
| Can I run a macro to create a pivot table? | Excel Discussion (Misc queries) | |||
| Error when runing macro to create pivot table | Excel Programming | |||
| Macro to create pivot table/ chart | Excel Programming | |||
| Is it possible to assign a macro to a pivot table? | Excel Programming | |||
Threaded Mode
