Create pivot table
 

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:=xlDatab ase, SourceData:= _
"DATATABLE").CreatePivotTable TableDestination:="ROLLUP!A4",
TableName:= _
"PivotTable2", DefaultVersion:=xlPivotTableVersion10

Create pivot table
 

Try "ROLLUP!R4C1". I don't think pivot table recognise the A4 type cell
addressing.

Regards,

OssieMac


"Almagg" wrote:

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:=xlDatab ase, SourceData:= _
"DATATABLE").CreatePivotTable TableDestination:="ROLLUP!A4",
TableName:= _
"PivotTable2", DefaultVersion:=xlPivotTableVersion10

Create pivot table
 

that was it.
thanks.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200704/1