Macro to return range selected

[chimpydude]

Hi guys,

Long time admirer, first time questioner.

I wonder if anybody knows of a macro which will return the range which has been selected. For example, if I highlight cells B1:E2, the macro will return the value "B1:E2"?

Thanks in advance!

 

[offthelip]

try this:

Dim myrange As Range

Set myrange = Selection
ttt = myrange.Address




MsgBox ttt

 

[Fluff]

Another option

MsgBox Selection.Address(0,0)

 

[chimpydude]

This works like a charm, thank you so much!

 

[Fluff]

Glad we could help & thanks for the feedback