View Single Post
  #1   Report Post  
Gaura215 Gaura215 is offline
Junior Member
 
Location: India
Posts: 24
Send a message via Skype™ to Gaura215
Unhappy 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