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
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
Originally Posted by ilyaskaziDim rng Set rng = Range("E2:E23") MsgBox rng.Row & ":" & rng(rng.Count).Row
thankyou