Learn different ways to find the last row of a dataset in Excel. We will go through each technique on a high level. Having so many ways to find the last row may get confusing. I will explain my own preferences as we move along.
Each of these techniques can be adapted to find the last column or last cell address as well.
You can find all the code covered in this video at:
https://skillsandautomation.com/usefu...
I have separate videos deep diving into each last row technique:
Find last row using Range.End: • Excel VBA: How to Find the Last Row Using ...
Find last row using CurrentRegion and UsedRange: • Excel VBA: How to Find the Last Row Using ...
Find last row using SpecialCells: • Excel VBA: How to Find the Last Row Using ...
Find last row using Find: • Excel VBA: How to Find the Last Row Using ...
Find last row using Tables: • Excel VBA: How to Find the Last Row Using ...
#VBALastRow #ExcelLastRow
Also, check out my comprehensive Youtube course to get you started with programming in Excel VBA. Complete beginner's tutorial designed to take you straight into the heart of VBA.
• Learn Excel VBA Programming [Practical Tut...
0:00 Intro
1:08 Range End
3:56 Current Region
6:25 Used Range
8:17 Special Cells
11:23 Find
16:07 Tables
18:20 My Preferences
19:50 Wrap Up