I recorded a macro of the creation of a pivot table.
The bit of code that does the business is shown below.
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:="'ALL'!R1C2:R1655C7").CreatePivotTable TableDestination:="", _
TableName:="PivotTable1"
My problem...