I am doing a simple 'record' of doing a basic Pivot Table, but when I run the recorded macro on the same sheet with the same data, I get the following code highlighted as being a problem:
Is there something special that needs to be done in order to record a basic Pivot Table macro?
Thanks!
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"working copy (2)!R1C1:R70C4", Version:=7).CreatePivotTable TableDestination _
:="working copy (2)!R3C6", TableName:="PivotTable2", DefaultVersion:=7
Is there something special that needs to be done in order to record a basic Pivot Table macro?
Thanks!
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"working copy (2)!R1C1:R70C4", Version:=7).CreatePivotTable TableDestination _
:="working copy (2)!R3C6", TableName:="PivotTable2", DefaultVersion:=7