pivot tables...what a nightmare!!!!!!

[danno_mbk]

hey there, I am certainly picking your brains today !

I have a pivot table and its seriously doing my head in I have spent ages trying to sort this out.
basically I have a table of data and I want the pivot to appear in another sheet which is named 'temp', but the flippin thing doesnt like it..


ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"'WL PCLT'!R1C1:R31C16").CreatePivotTable TableDestination:=Range("'PCLT Temp'!$A$1"), _
TableName:="PivotTable1"

("'PCLT Temp'!$A$1"), this bit of code I entered to specify the sheet, it should be "A1" (thats what appears when I record the thing, but there is no where in teh recorded code to specify where the destination sheet for the pivot able is ???

any ideas would be much appreciated, as I have got to the point of bining it and going home !
cheers
Danno

 

[danno_mbk]

sorted !

I forgot to enter the destination sheet at the start of the code..

oops