ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:=Pivotrange, Version:=xlPivotTableVersion15).CreatePivotTable TableDestination:="Sheet1!R3C1", TableName:="PivotTable1", DefaultVersion:=xlPivotTableVersion15
Hi,
Need help with the attached code. The code to generate Pivot...