Forum Discussion
Creating a Macro to create a pivot table using a dynamic number of rows
Hi all, So I'm now at the very limit of my abilities ... trying to record and then debug macros - Is there anyone out there that can help? What I'm trying to accomplish is this: 1. Export ...
This is the initial error I'm getting highlighted yellow in the VBA editor
Sheets.Add
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"GridData!R1C1:R443C21", Version:=6).CreatePivotTable TableDestination:= _
"Sheet1!R3C1", TableName:="PivotTable3", DefaultVersion:=6