View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nicodemus Nicodemus is offline
external usenet poster
 
Posts: 14
Default 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