PivotTableDestination

  • Thread starter Thread starter moglione1
  • Start date Start date
M

moglione1

Can anybody please tell me how you add a pivot table to an existing
sheet using VBA. I currently have the code:

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, _
SourceData:="=Data").CreatePivotTable TableDestination:="", _
TableName:="Part2"

PLEASE PLEASE HELP
 
You can specify the sheet and range in the TableDestination argument:

TableDestination:=Sheets("Pivot").Cells(3, 1)
 

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
pivot tables macro 14
Record Macro to Create Pivot Table 1
Pivot table with a variable range in the sourcedata field 2
Pivottable code problem 4
MACRO FOR PIVOT TABLE 2
Build Pivot Table with VBA; Keeps Throwing an Error 1
Pivot table in VB 3

Back
Top