Create pivot table

  • Thread starter Thread starter Almagg
  • Start date Start date
A

Almagg

here is the code from a recorded macro:
the items in caps are what i entered afterwards.
DATATABLE is a named range
what does not to be working is the [TableDestination:="ROLLUP!A4] part.
i want to put the pivot table in the RollUp sheet starting at cell A4
thanks for any help

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"DATATABLE").CreatePivotTable TableDestination:="ROLLUP!A4",
TableName:= _
"PivotTable2", DefaultVersion:=xlPivotTableVersion10
 
Try "ROLLUP!R4C1". I don't think pivot table recognise the A4 type cell
addressing.

Regards,

OssieMac
 
Back
Top