Need your help

[ashokbioinfo]

I have created pivot table using macro recording as I don't know much more about programming. I want to copy the whole pivot into a new sheet. and delete the old sheet. what is the macro I need to add.
I am getting error while shifting pivot to other sheet


ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"Data!R1C1:R65536C3", Version:=xlPivotTableVersion10).CreatePivotTable _
TableDestination:="Sheet5!R3C1", TableName:="PivotTable3", DefaultVersion _
:=xlPivotTableVersion10

Advance thanks for your help.

[Sisyphus]

Hi,
I've been waiting for Don to find your question because he knows about pivot tables as well as more recent versions of Excel. You are using Excel 2010, right?
I'm struck by the R1C1 references in the formula you published. Have you tried to replace them with A1 type references reflecting your actual needs? Can you upload a sample workbook? I can't quite imagine a circumstance where this removal of a pivot table from an existing to a new sheet would be repetitive. Can you explain the purpose? It might help finding the best solution.
Have a great day!