Fill pivot with selected value

[jomili]

At the opening of my workbook I have a listbox allow my user to select the region they want to see. This value is populated into cell D2 of my "Steps" worksheet. My code for updating my pivot code has the line shown below. How would I go about changing this line so, instead of "010", the value would the value in cell D2 on "Steps"? Thanks in advance for any help on this.

Please Login or Register  to view this content.

[romperstomper]

Please Login or Register  to view this content.

[jomili]

Thanks Romper. That's the exact code I tried, and got a "Subscript out of Range" error. When you posted the same code I decided to look closer and realized I needed to reference the workbook that "Steps" was in. That did the trick. Thanks so much for pointing me in the right direction.

Thanks,
John