View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
DM Unseen DM Unseen is offline
external usenet poster
 
Posts: 233
Default Get Range, that user marked

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