Select the Last Row in Named Range

[MarshalG]

Hi all,

I would like to add a line to my macro that selects the last row in a named range ("Report").

I've tried looking for this throughout this forum and I can't seem to find an answer to this problem.

Thanks a lot!

 

[MickG]

Hi, Try this:-

[COLOR="Navy"]Sub[/COLOR] MG26Mar24
[COLOR="Navy"]With[/COLOR] Range("MyRng")
 .Range("A" & .Rows.count).EntireRow.Select
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]With[/COLOR]
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]

Regards Mick

 

[doofusboy]

For multi-row range name:
Rows(Split(ThisWorkbook.Names("Report").RefersToRange.Address, "$")(4)).Select

For single-row range name:
Rows(Split(ThisWorkbook.Names("Report").RefersToRange.Address, "$")(2)).Select

 

[Joe4]

Welcome to the Board!

Another way:

Rows(Range("Report").Rows.Count + Range("Report").Cells(1, 1).Row - 1).EntireRow.Select

 

[MarshalG]

Perfect. Thanks a lot.