I can't find a fix for my VBA problem. Help please?

[Justinidea]

When I run this code to create a PivotCache, it fails after the first pivot table is created.

It hangs up on the TableName:="PivotTable1".

Can someone tell me how to reset the TableName?

ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"Pivot_Table_Range", Version:=xlPivotTableVersion12). _
CreatePivotTable TableDestination:="Pivot", TableName:="PivotTable1" _
, DefaultVersion:=xlPivotTableVersion12

Thanks!

Mike

 

[Justinidea]

Hmmm. Found the answer in the most unlikely place... Support.Microsoft.com... lol

Error message when you play a recorded macro to create a PivotTable in a new worksheet in Excel 2007: "Run-time error '1004': Application-defined error" or "Run-time error '5': Invalid procedure call or argument"