<tbody>
[TD="class: votecell"]
[/TD]
[TD="class: postcell"]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>
[/TD]
</tbody>
