Hello,
I have a pivottable in Excel in which I want to select the first item, print the data, select the next, print the data etc until the last one. Not every item is always in the list.
Now I do it manual, but I want to automate it.
Now I have this VB:

**
Sheets("PivotInfo").Select
ActiveSheet.PivotTable
("PivotPosted").PivotFields("Dealer").CurrentPage = "item1"
ActiveWindow.SelectedSheets.PrintOut Copies:=1
**

Now I want the script to select the next item after item1 is printed.

Any help will be appreciated!

Thanks,
Mark.