Getting Debug Error
Whats wrong in this code:
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDa tabase, SourceData:= _
"Dump!R1C1:R500C40", Version:=xlPivotTableVersion12).CreatePivotTable _
TableDestination:="Slide 07 - Global!R2C2", TableName:="PivotTable1", _
DefaultVersion:=xlPivotTableVersion12
Simply recorded a pivot creation macro, but I am running it, it always get debugged here.
__________________
Regards
Gaurav
|