Get Row # of last row in UsedRange 1

[rguglielmon]

How do I get the row number of the last row in a range returned by the UsedRange property of a Worksheet? In other words, what is the last row used in the sheet?

I have been using ActiveSheet.UsedRange.Rows.Count but just realized that this doesn't work if the worksheet does not use rows at the top.

 

[SkipVought]

hi,

With ActiveSheet.UsedRange
  FirstRow = .Row
  LastRow = Firstrow + .Rows.Count - 1
End with

Skip,
[sub]
[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive! [/sub]