range info of a selection

[BoFenger]

Hi
When I select a range in a excel sheet I would like to get the range info of what I have selected, something like

dim test as range

test=selection.range.info

and "test" is now Range("A1:C3")

how do I do this
Br Bo

 

[JAG14]

You are probably looking for the SELECTION Property
This will return the current selected range in the form of a Range Object assuming you have selected cells.

See "Selected Property" in VBA Excel Help for more information.

And in future, please post Excel, Access and General VBA questions in Forum707

HTH

JaG

[tt]'Very funny, Scotty... Now Beam down my clothes.'[/tt]
​

 

[SkipVought]

Hi,

Take a look at the Address property of the Range Object.

Skip,

_[red][/red]