Excel VBA: How to Find the Last Row Using Range.End

Опубликовано: 28 Сентябрь 2024
на канале: Skills and Automation
1,672
22

Learn how to find the last row of a dataset in an Excel worksheet using the Range.End technique.
There are many instances where we need to determine the last row. In this video, we will cover 3 basic examples using the Range.End 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 CurrentRegion:    • Excel VBA: How to Find the Last Row U...  
Find last row using SpecialCells:    • Excel VBA: How to Find the Last Row U...  
Find last row using Range.Find:    • Excel VBA: How to Find the Last Row U...  
Find last row using Tables:    • Excel VBA: How to Find the Last Row U...  

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 ...  


0:00 Intro
0:15 Why Find the Last Row
1:40 Excel Walk Through
4:40 VBA Code
9:16 Example 1 (Identify Range)
13:06 Example 2 (Copy Range)
14:06 Example 3 (Paste New Data Below Range)
15:44 Wrap Up