Finding and referencing a second set of data

[dudewheresmyvba]

I have two sets of data. One offset from the other but directly below it. I want to do things to the second set but do not know how to reference it because they both change per iteration of the data.

So example:
My top set of data is A1:L11.
There are 4 blank rows between them.
And the second set is A16:L46

vs

Top set is A1:L21
4 blank rows
Bottom set is A:26:L155

I want to be able to find and name the range for the bottom set like i did with the top with CurrentRegion.Select. I have been fooling around with the .End(xlUP) but am not quite there.

Let me know if there is any more info you need.

 

[Joe4]

Assuming that your data starts in cell A1 and there is always at least two rows of data in the first section, see if this works for you:

    Dim myRange As Range
    Set myRange = Range("A1").End(xlDown).End(xlDown).CurrentRegion
    myRange.Select

It will assign the second group to a Range variable named "myRange" which you can then reference in your code.
I added the last line to select it, just to show you visually what range has been assigned to this variable.

 

[dudewheresmyvba]

Wow that is beautiful. I had no idea you could use .End(xlDown) twice in a row. Thanks so much!

 

[Joe4]

You are welcome!