Get selected range address w/o column name

[ilyaskazi]

I want to know range of rows selected without its column name

Suppose range selection is= E9:E23 then
I want the output.. msgbox1= 9:23, msgbox2= 9 to 23

[Bob Phillips]

I want to know range of rows selected without its column name

Suppose range selection is= E9:E23 then
I want the output.. msgbox1= 9:23, msgbox2= 9 to 23


Dim rng
Set rng = Range("E2:E23")
MsgBox rng.Row & ":" & rng(rng.Count).Row

[ilyaskazi]

thankyou

:beerchug: