I'd like to use VBA to cycle through all the available options for one of the pivot table's report filters (and print between each cycle).
The loop I envision is for i = 1 to # of entries in Report Filter: AgentName, and in each loop select the next entry and a little extra code (create a graph, print a report). The part I need help with is figuring out how to have it loop through the available entries in the Report Filter.
Thank you!