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

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

try so

Please Login or Register  to view this content.

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)

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

Originally Posted by ammartino44

I want C2:E3.

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Nice Nilem. That's that good good.

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

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