Excel VBA: How to Find the Last Row Using CurrentRegion and UsedRange

Learn how to find the last row of a dataset in an Excel worksheet using the CurrentRegion technique.
There are many instances where we need to determine the last row. In this video, we will cover 3 basic examples using the CurrentRegion technique.
We will also, discuss UsedRange for times when CurrentRegion is inadequate.

You can find all the code covered in this video at:

There are different ways to find the last row. I have separate videos on them as well.

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.

0:00 Intro
0:25 Why Find the Last Row
1:54 Excel Walk Through
4:25 VBA Code
8:35 Example 1 (Identify Range)
9:46 Example 2 (Copy Range)
11:22 Example 3 (Paste New Data Below Range)
12:39 Used Range
14:13 Delete Extra Rows
15:52 Wrap Up

[robespain]

Thanks my friend. Very well explained.

[kumarsravan]

Very useful but declaration of variables and strings if you explain deeply will be helpful 👏👏