tintin1012000
Board Regular
- Joined
- Apr 27, 2011
- Messages
- 237
Im trying to set up a macro to simply use data in a tab to created a pivot table
im getting a run-time error ''5'' and when i go to debug the below text is highlighted in yellow
any ideas ?
[ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"Error rawdata!R1C1:R1704C14", Version:=xlPivotTableVersion10). _
CreatePivotTable TableDestination:="Error dashboard!R2C2", TableName:= _
"PivotTable4", DefaultVersion:=xlPivotTableVersion10'']
im getting a run-time error ''5'' and when i go to debug the below text is highlighted in yellow
any ideas ?
[ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"Error rawdata!R1C1:R1704C14", Version:=xlPivotTableVersion10). _
CreatePivotTable TableDestination:="Error dashboard!R2C2", TableName:= _
"PivotTable4", DefaultVersion:=xlPivotTableVersion10'']