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?
Bookmarks