My macro refreshes the pivot and also moves some pivot fields up and down in pivot, like
ActiveSheet.PivotTables("PivotTable4").PivotFields("OS Banding").PivotItems( _
"91 - 120").Position = 2
But if one field namely PivotItems( _"91 - 120") doesnt exist in the pivot (when pivot is made with the new data) can the macro skip this and move forward without giving an error?? Please help.
ActiveSheet.PivotTables("PivotTable4").PivotFields("OS Banding").PivotItems( _
"91 - 120").Position = 2
But if one field namely PivotItems( _"91 - 120") doesnt exist in the pivot (when pivot is made with the new data) can the macro skip this and move forward without giving an error?? Please help.