RangeSelection Property Example
This example displays the address of the selected cells on the worksheet in the active window.
MsgBox ActiveWindow.RangeSelection.Address