Show the actual range selected ie a1:b4 1

[daveonion]

Hi,

I have a variable called my_rng this is derived from a user choosing a range within an Input Box. However i want to put the range selected in a msgbox but I am not sure what the property is ie i want the msgbox to say range selected is a1:B4, any assitance would be appreciated thanks

 

[macropod]

Hi dave,

Try:
MsgBox Selection.Address

Cheers

[MS MVP - Word]

 

[SkipVought]

Actually, with

MsgBox Selection.Address

you get the ABSOLUTE range. You may want that or not.

You can show the RELATIVE range

MsgBox Selection.Address(False, False)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}