Create pivot table

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

that was it.
thanks.

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2007 - Create Pivot table from another pivot table	=?Utf-8?B?VG9tIEJlcmdtYW4=?=	Microsoft Excel Discussion	5	17th Nov 2007 12:51 AM
how to create pivot table from existing pivot table in excel 2007	=?Utf-8?B?VWRheXJhaiBEaHVsZWthcg==?=	Microsoft Excel Misc	1	15th Dec 2006 04:23 AM
How do I create multiple pivot charts from one pivot table?	=?Utf-8?B?UnVkeQ==?=	Microsoft Excel Charting	1	17th Mar 2006 10:01 PM
RE: pivot table: create worksheetsheet using pivot table	=?Utf-8?B?UGl2b3QgVGFibGVzIGFuZCBOZXcgV29ya3NoZWV0	Microsoft Excel Misc	1	1st Jun 2005 10:01 PM
How do I create a pivot table if the pivot table icon or menu ite.	=?Utf-8?B?THlubkBXUw==?=	Microsoft Excel Charting	1	16th Dec 2004 02:36 AM