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

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

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