My client has an Excel 2007 pivot table with a report filter. The client wants to sequentially change the report filter, cycling through all of the options in order.

How can this be done in VBA?