View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
norrislaketn norrislaketn is offline
external usenet poster
 
Posts: 14
Default 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.