run-time error ''5''

[tintin1012000]

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'']

 

[steve the fish]

If sheet names have spaces in them they need to be enclosed by single quotes ' ........... '

Try that.