I am trying to filter an OLAP pivot table based on an external cell value and can;t find anything that works. Below is a snippet of my code that I'm trying to get working, so here is my question...How do I pass the "filterProj" variable value to the highlighted text? [0000006.00 - Information Technology]

filterProj = Worksheets("Summary").Range("B2").Text

ActiveSheet.PivotTables("PivotTable2").PivotFields( _
"[Projects].[Project Tree by Number].[Project Number - Short Name]"). _
CurrentPageName = _
"[Projects].[Project Tree by Number].[Project Number - Short Name].&[0000006.00 - Information Technology]"

Thanks,
Heath