I've got a macro manipulating a pivot table, and I'm having trouble selecting one part of my data range. The errant line from my macro is below.
The problem is that the title is formatted like this:PivotFields("Data").PivotItems(" Revised Current Month Projected ").DataRange.Select
, and I don't know how to put that into my code. Any help is highly appreciated.(space)Revised(skip down a line) Current Month Projected
Bookmarks