Pivot Table - CurrentPageList

[xlStar]

I am trying to print every items listed on the "CurrentPageList" within the Pivot Table.

Below is an extract from VBA Excel Help Page...

pvtField.CurrentPageList = "[Product].[All Products].[Food]"

How can I count the number of items within CurrentPageList so that I can go thorugh each items for printing? My list is date format and that will change every month so I can just select "01/01/2007".

 

[SkipVought]

Hi,

Please post VBA questions in Forum707.

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}