finding the last row in a worksheet

[Bill Meng]

I'm attempting to determine the last row in a worksheet. I did it once
using Usedrange.

 

[Vasant Nanavati]

Sheet1.UsedRange.Row + Sheet1.UsedRange.Rows.Count - 1