VBA - selecting multiple pivot items within a pivot field

Hi there

I have a pivot table that contains (amongst other things) various time periods that i need to update to return the correct data.

The time periods are split into years and quarters so for each time period i want, i need to select one of each.

This is fine for a single year/period, however on a number of occasions i need to report inception to date, i.e. all the periods up to the current (or specified) period.

I want to load all the years and periods into an array and then unload the array into the pivot, selecting all the periods, but i can't work out how to do so.

For example, one lines of the code i am using looks like this:

With ActiveSheet.PivotTables("PivotTable1").PivotFields("[Accounting Period].[Accounting Period]")
.AddPageItem "[Accounting Period].[Accounting Period].[Acct Year].&[" & FinancialYear & "].&[Qtr " & Quarter & "]"
End With

where FinancialYear is a variable and Quarter is also a variable. This will select one period only. I want to cycle through all available periods from, say, 2008.

Any help much appreciated.

Thanks

Titus