I have code that pulls data from a pivot table and places it another table. It will work fine until it tries to do a look up in the pivot table for a value that isn't listed in the pivot table. The Pivot table is based on pulls from our ticketing system so it might not have tickets from all the regions but the table I'm pulling the data for lists all the regions. If I was getting a #NA or a #REF I would just check for it and change it to 0 but I'm getting a Run Time Error 1004.
Any help would be nice
ActiveCell = (ptSysTotal.GetPivotData("Duration by Time and Impact", "System", ActiveCell.Offset(0, -1).Value & " "))