View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Magnivy Magnivy is offline
external usenet poster
 
Posts: 70
Default Return Rows of Selected Range in a Pivot

I'm trying to figure out how to return the rows of a selected range in a
pivot table. For Example, when I record a macro to select all 2001s in my
pivot table, I get the following code:

ActiveSheet.PivotTables("PivotTable1").PivotSelect "'2001'", xlDataAndLabel,
_ True

I'm trying to return the rows of all the selected items, so that I could set
the rows of these items to a certain height, but cant come up with anything.

Any help would be greatly appreciated.

Thanks,
Magnivy