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