Pivot Table Page Area selections in a macro

Is there an easy method to select multiple page area values to populate a
pivot table.

Example: A page area named "state" would list all 50 states but in a macro I
only want the states of Georgia and Tennessee. I do not want the user to have
to manually select. Just use a command button.

Try doing it manually with the macro recorder turned on. That will give you
some good sample code to start with.

--
Regards,
Tom Ogilvy


"norrislaketn" wrote:

> Is there an easy method to select multiple page area values to populate a
> pivot table.
>
> Example: A page area named "state" would list all 50 states but in a macro I
> only want the states of Georgia and Tennessee. I do not want the user to have
> to manually select. Just use a command button.

Tried that and also tried adding the selection manually,see below.

Sheets("Rpt").PivotTables("PivotTable1").PivotFields("Area").CurrentPage =
"GEORGIA", "TENNESSEE"

It is only returning the first states data.

"Tom Ogilvy" wrote:

> Try doing it manually with the macro recorder turned on. That will give you
> some good sample code to start with.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "norrislaketn" wrote:
>
> > Is there an easy method to select multiple page area values to populate a
> > pivot table.
> >
> > Example: A page area named "state" would list all 50 states but in a macro I
> > only want the states of Georgia and Tennessee. I do not want the user to have
> > to manually select. Just use a command button.

I couldn't record anything like that.

Are you working with OLAP data? If not, what is your data source? Excel
sheet, access database, what?

--
Regards,
Tom Ogilvy


"norrislaketn" wrote:

> Tried that and also tried adding the selection manually,see below.
>
> Sheets("Rpt").PivotTables("PivotTable1").PivotFields("Area").CurrentPage =
> "GEORGIA", "TENNESSEE"
>
> It is only returning the first states data.
>
> "Tom Ogilvy" wrote:
>
> > Try doing it manually with the macro recorder turned on. That will give you
> > some good sample code to start with.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "norrislaketn" wrote:
> >
> > > Is there an easy method to select multiple page area values to populate a
> > > pivot table.
> > >
> > > Example: A page area named "state" would list all 50 states but in a macro I
> > > only want the states of Georgia and Tennessee. I do not want the user to have
> > > to manually select. Just use a command button.

SQL Server database

"Tom Ogilvy" wrote:

> I couldn't record anything like that.
>
> Are you working with OLAP data? If not, what is your data source? Excel
> sheet, access database, what?
>
> --
> Regards,
> Tom Ogilvy
>
>
> "norrislaketn" wrote:
>
> > Tried that and also tried adding the selection manually,see below.
> >
> > Sheets("Rpt").PivotTables("PivotTable1").PivotFields("Area").CurrentPage =
> > "GEORGIA", "TENNESSEE"
> >
> > It is only returning the first states data.
> >
> > "Tom Ogilvy" wrote:
> >
> > > Try doing it manually with the macro recorder turned on. That will give you
> > > some good sample code to start with.
> > >
> > > --
> > > Regards,
> > > Tom Ogilvy
> > >
> > >
> > > "norrislaketn" wrote:
> > >
> > > > Is there an easy method to select multiple page area values to populate a
> > > > pivot table.
> > > >
> > > > Example: A page area named "state" would list all 50 states but in a macro I
> > > > only want the states of Georgia and Tennessee. I do not want the user to have
> > > > to manually select. Just use a command button.