No, I want "ROWNUMBER:COLNUMBER" format for a selected range.
I don't know the "A1:C1" in my example. I want to determine that string.



"Dave Peterson" wrote:

dim myRng as range
set myrng = activesheet.range("a1:C10")
msgbox myrng.address(0,0)

Take a look in VBA's help for .address.

Raph wrote:

Hi.
I have a range object. I want to determine the:

"A1:C10"

Format of the range. How do I get that?

Thanks

--

Dave Peterson