run time error 5 in macro

[TM61404]

hello,

i am trying to debug this code and am having a really hard time trying to find the root of this issue. the macro creates a simple pivot table and im not sure if there is a nother pivot table that has the same name and where to even locate this pivot table. i thought i started from scratch a few times by completely rebulilding the macro to no avail please help. again the error message is run time error 5 invalid procedure call or argument

ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"FRONT END!R4C2:R164C8", Version:=xlPivotTableVersion14). _
CreatePivotTable TableDestination:="FRONT END!R4C13", _
TableName:="PivotTable3", DefaultVersion:=xlPivotTableVersion14

 

[TM61404]

hello,

i am trying to debug this code and am having a really hard time trying to find the root of this issue. The macro creates a simple pivot table and im not sure if there is a nother pivot table that has the same name and where to even locate this pivot table. I thought i started from scratch a few times by completely rebulilding the macro to no avail please help. Again the error message is run time error 5 invalid procedure call or argument

activeworkbook.pivotcaches.create(sourcetype:=xldatabase, sourcedata:= _
"front end!r4c2:r164c8", version:=xlpivottableversion14). _
createpivottable tabledestination:="front end!r4c13", _
tablename:="pivottable3", defaultversion:=xlpivottableversion14

i figured it out. It was due to the words front end not having an underscore in between them