ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Identify Range Selected By User (https://www.excelbanter.com/excel-programming/287361-identify-range-selected-user.html)

RonF

Identify Range Selected By User
 
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.




Beto[_3_]

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.



All times are GMT +1. The time now is 09:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com