Pivot Table Page Area selections in a macro
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").PivotFiel ds("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.
|