Thread: Assign a macro to create a pivot table
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
acsugguiyao acsugguiyao is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote