PivotTableDestination
 

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:=xlDatab ase, _
SourceData:="=Data").CreatePivotTable TableDestination:="", _
TableName:="Part2"

PLEASE PLEASE HELP


--
moglione1
------------------------------------------------------------------------
moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=508433

PivotTableDestination
 

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

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

moglione1 wrote:
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:=xlDatab ase, _
SourceData:="=Data").CreatePivotTable TableDestination:="", _
TableName:="Part2"

PLEASE PLEASE HELP




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html