Learn how to find the last row of a dataset in an Excel worksheet using the SpecialCells technique.
There are many instances where we need to determine the last row. In this video, we will cover 3 basic examples using the SpecialCells technique.
You can find all the code covered in this video at:
https://skillsandautomation.com/how-t...
There are different ways to find the last row. I have separate videos on them as well.
Find last row using Range.End: • Excel VBA: How to Find the Last Row Using ...
Find last row using Current Region: • Excel VBA: How to Find the Last Row Using ...
Find last row using Range.Find: • Excel VBA: How to Find the Last Row Using ...
Find last row using Tables: • Excel VBA: How to Find the Last Row Using ...
I also, have a video that goes through all techniques in a single video where we see when to use which technique and cover my preferences as well.
5 Ways to Find the Last Row: • Find the Last Row Using Excel VBA [5 Diffe...
0:00 Intro
0:14 Why Find the Last Row
1:33 Excel Walk Through
4:10 VBA Code
5:38 Example 1 (Identify Range)
7:21 Example 2 (Copy Range)
8:19 Example 3 (Paste New Data Below Range)
10:15 Delete Blank Rows
11:34 Wrap Up