How do you select a range (using last row/last column)

[ammartino44]

Hello. How can I select the range that aligns with the last row and last column in this sheet? C2:E3 in attached sheet.

[nilem]

try so

Range("A1").CurrentRegion.Select

[ammartino44]

That doesn't select the area that I want. I want C2:E3.

[nilem]

I want C2:E3.

With Range("A1").CurrentRegion
    .Offset(1, 2).Resize(.Rows.Count - 1, .Columns.Count - 2).Select
End With

[ammartino44]

Nice Nilem. That's that good good.

[ammartino44]

And once I figure out how to select the range, how can I fill it with formulas like this. =SUMIFS(Master!$D$2:$D$5,Master!$C$2:$C$5,'101'!$B2,Master!$B$2:$B$5,'101'!C$1)

[JOHN H. DAVIS]

Maybe:

Sub ammartino44z()
Dim x As Long, y As Long, z As Long
x = Range("A" & Rows.Count).End(3).row
y = Cells(1, Columns.Count).End(xlToLeft).Column
z = Range("C" & Rows.Count).End(3)(2).row
Range(Cells(z, 3), Cells(x, y)).Select
End Sub

[ammartino44]

@ John "Big" D. What does End(3) mean? And what does End(3)(2) mean? Danks.

[JOHN H. DAVIS]

End(3) - same as End(xlUp)
End(3)(2) - same as End(xlUp).Offset(1)