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

Learn how to find the last used row, cell, or column in a worksheet using VBA. In this video I explain the Range.SpecialCells method which will help find the last used cell on the worksheet. This is different than the last non-blank cell.

Watch PART 1 (End Method): https://www.youtube.com/watch?v=vw1zIAyfzro
Watch PART 2 (Find Method): https://www.youtube.com/watch?v=6PLmcweo50I

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
00:00 Introduction
00:30 Last Used Cell
01:26 SpecialCells Method
03:24 Limitations
04:36 Conclusion