identify first row after subtotals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thank you for the advice.
The first row will always contain data.
The most important for me is to identify the first row ;)
 
Back
Top