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
Bob Phillips
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:
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.