Get Last Used Row Of Column Or Worksheet in Excel Using VBA
Finding the last used row of a range or worksheet is probably one of the most important and common tasks when automating using VBA. In this video, we look at two methods:
1. Using xlUp
2. Using the Find function
xlUp works well but it doesn't give the correct result if you have hidden rows. Use the Find function if you want to take hidden rows into account and it can also be modified to find the last row of the entire sheet and not just a column.