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.Find method which is the best method to use when your data contains blank cells.

Watch PART 1 (End Method): https://www.youtube.com/watch?v=vw1zIAyfzro
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
00:00 Introduction
00:49 The Range Find Method
05:44 RangeFind Example
13:04 Conclusion