Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify first row after subtotals
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify first row after subtotals
Be careful with your last row thing, it only works if Row 1 has something in
it. I would recommend that you use this instead: LastRow = ActiveSheet.UsedRange.Cells _ (ActiveSheet.UsedRange.Rows.Count,1).Row -- Charles Chickering "A good example is twice the value of good advice." "Nicodemus" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
identify first row after subtotals
Thank you for the advice.
The first row will always contain data. The most important for me is to identify the first row ;) "Nicodemus" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |