Find Last Used Row even if Hidden

[k64]

I have a worksheet for data entry. I've added data validation thousands of rows ahead of the last used row, so that I won't "run out". To get the last used row, I use Range("A1000000").End(xlUp).Row. If I use UsedRange.Rows.Count it counts the thousands of blank rows with data validation. Sometimes, rows are hidden and End(xlUp) skips them. How do I find the last used row, even if it is hidden?

[Kaper]

Check Ron de Bruin solution: http://www.rondebruin.nl/win/s9/win005.htm

[k64]

Thanks!

For posterity: the solution I used was

Please Login or Register  to view this content.