note:
use Address(External:=True) to get a proper fully qualified string.



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam

Bob Phillips wrote in message
:

When the range is selected this way, it because the selection, so just
use

Selection.Address

or Selection.Address(False, False)

if you don't want the $s. Note that this doesn't get the worksheet
name as well.