Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create pivot table
that was it.
thanks. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200704/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
How do I create multiple pivot charts from one pivot table? | Charts and Charting in Excel | |||
pivot table: create worksheetsheet using pivot table | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
create pivot table linked to another pivot? possible? | Excel Programming |