My apologies for answering just with text, I’m answering from my phone.
I have 3 lines that are similar, each one refers to a different pivot table. I get the error if “MXG” is missing from the list.
ActiveSheet.PivotTables("PivotTable13").PivotFields("Work Center").CurrentPage _ = "MXG"
I was trying to get it to recognize if “MXG” was not available to default to “(blank)” as that’s an option that is always available.