Create pivot table

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
 
G

Guest

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

Regards,

OssieMac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Macro with dynamic source data 1
Avoiding an extra sheet when creating a pivot table 3
Build Pivot Table with VBA; Keeps Throwing an Error 1
Playing back a Pivot Table macros 2
Why R1C1 range parameters in VBA Pivot Table setup/ 18
Excel TableDestination As String? 1
Pivot table Macro help!!! 3
Pivot table code question 2

Top