Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

Learn how to find the last used or non-blank row, cell, or column in a worksheet using VBA. In this video I explain the Range.End method which works well when your data does not contain blank cells.

Watch PART 2 (Find Method): https://www.youtube.com/watch?v=6PLmcweo50I
Watch PART 3 (SpecialCells): https://www.youtube.com/watch?v=BLxBm1yq4Js

Download the file that contains the code + full article: http://www.excelcampus.com/vba/find-last-row-column-cell/

Free email newsletter: http://www.excelcampus.com/newsletter