PDA

View Full Version : Solved: Get selected range address w/o column name



ilyaskazi
06-29-2005, 10:40 PM
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

xld
06-30-2005, 01:24 AM
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
06-30-2005, 03:02 AM
thankyou

:beerchug: