Edit VBA code to select last cell in named range

Hi everyone,

I named a range [mranges] with offset formula to make it dynamic, now i need vba code so that selects the last cell in [mranges].

Sub Method2()
Dim ws As Worksheet
Dim rng1 As Range
Set ws = Sheets("Data")
[mranges].Select
End Sub

The last last cell in [mranges] is used to condition another macro.

P.S
If anyone could also edit the vba so that it shows the address and value of the last cell in [mranges] via msgbox that would be an extra.

Thanks.