| I keep getting this error Unable to get the PivotTables property of the Worksheet class from the code below (I used recording button to have these coding from Excel) I'm not sure what is wrong, but any help would be helpful. It hung up at the "<code>With ....End With"</code> part. <code>ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase,SourceData:="Report1&2!R1C1:R1048576C126", Version:=xlPivoTableVersion14).CreatePivotTable TableDestination:="EID_Graph!R1C1",TableName:="PivoTable1", DefaultVersion:=xlPivotTableVersion14 With ActiveSheet.PivotTables("PivotTable1").PivotFields("ID_1") .Orientation = xlRowField .Position = 1 End With</code> |
<tbody>
</tbody>