Hi Guys

I am automating with VBA a process which creates a pivot table.

The problem i have is that I would like to set the destination of th
new pivot table to a specific sheet instead of "sheet1" (or the nex
number as happens by default). I tried using the option "use existin
sheet" in the pivot sheet creation dialogue box however no VBA cod
appears to be created for assigning the pivot table to a specificall
named pivot sheet. i.e. the new pivot sheet always tries to put itsel
on "Sheet1".

Any suggestions ?

Thanks in advance

--
paz2
-----------------------------------------------------------------------
paz24's Profile: http://www.excelforum.com/member.php...fo&userid=3104
View this thread: http://www.excelforum.com/showthread.php?threadid=50761