in a scenario like "select range, press button" it's indispensable...

Sub DoButton()
MsgBox ActiveWindow.RangeSelection.Address
End Sub


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


DM Unseen wrote :

Actually,

Activewindow.RangeSelection gives back a range regardless what is
selected. It will give the last selected range if currently no range
is selected (when e.g. a shape is selected) This can be very handy or
very annoying depending on what you want.

Dm Unseen