View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Beto[_3_] Beto[_3_] is offline
external usenet poster
 
Posts: 140
Default Identify Range Selected By User

RonF wrote:

Is there a way I can identify a range selected by the user
when they use a mouse to select an area on the sheet? I
want to identify the cells that a user has highlighted.


If you want it as a range object, use "Selection".
Selection.Address will give you the range as a string.

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.