Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Identifying Beginning and Ending Rows in a Selected Range | Excel Programming | |||
delete row and 3 rows below by range selected | Excel Programming | |||
Function to return # of column with min value in selected rows | Excel Worksheet Functions | |||
Referring to a Range Based on Selected Rows | Excel Programming | |||
How to I return the position of a selected cell in a range? | Excel Programming |