Find the last cell address using vba excel - Stack Overflow

Regarding all the Range().End(xlUp).Row answers, this is a great solution and I use it often, but beware that if your sheet is Autofiltered when you call the function, it will return the last row of filtered data, not the actual last row of all data. – si

stackoverflow.com