Can you create a Macro that will create a Pivot

I am trying to create a Macro that will create a pivot table. I am getting the error below what I try to run the command. I have tried to have the pivot create a new tab for the pivot and I have tried creating the pivot on an already created tab. Any idea why I am getting this error?


ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"835!R1C1:R1048576C6", Version:=6).CreatePivotTable TableDestination:= _
"Sheet3!R3C1", TableName:="PivotTable2", DefaultVersion:=6

.

Please Login or Register  to view this content.

https://excelchamps.com/blog/vba-to-create-pivot-table/