Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Please Help!!!! Pivot problem

shardaluleshardalule Member Posts: 1
I have recorded the macro to create the dynamic report depend on the particular data .The code is working fine when i have recorded in MS 2007 but when i recorded in MS 2003 its giving me error as "Invalid Procedure call or argument.

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"Sheet1!R1C1:R3421C7").CreatePivotTable TableDestination:= _
"[Book1.xls]Sheet2!R2C1", TableName:="PivotTable1", DefaultVersion:= _

The part of code i have attached where i am getting the error.
Please can somebody help me out this its urgent!!!!

Sign In or Register to comment.