Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I would like to identify the number of the first row AFTER I've displayed the second row level of my subtotals. (ActiveSheet.Outline.ShowLevels RowLevels:=2) Example : 1 Name Points 10 Bob Total 30 17 Tim Total 40 25 Tom Total 50 26 Grand Total 120 The number of the first row here would be 10. To retrieve the last row I use : ActiveSheet.UsedRange.Rows.Count. Thank you in advance for any help. Nicodemus |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtotals problem: Excel 2003 (not, AFAIK, the nested subtotals bug) | Excel Discussion (Misc queries) | |||
Original subtotals should not be within nested subtotals in excel | Excel Worksheet Functions | |||
Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions |