Identify Range Selected By User

  • Thread starter Thread starter RonF
  • Start date Start date
R

RonF

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.
 
RonF said:
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.
Click to expand...

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

Regards,
 
Back
Top