Hi Kenneth. Thanks for the suggestion but it still throws the same error. It is worth mentioning that I'm trying to apply this filter at the Report Filter level. I was trying to think of a different way around this issue. Maybe looking at the raw data before it is pivoted, find the caption "New" or "RNw" within that data set, and assign that plan name to a variable. This way it is filtering on exactly what the plan element name is. I'm just trying to figure out the best way to look for a caption within a column and when it finds it assigning that cell value to a variable so that it would look like this:

Dim XVar as String (where XVar is the value of the cell that contains a specific string)

ActiveSheet.PivotTables("PivotTable1").PivotFields("Plan Element").CurrentPage _
= XVar

Any suggestions or advice would be greatly appreciated.