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,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table code question 2
Write a button to run macro on *ANY* chart area clicked. 1
Error Message - Macro to Unlink MS Queries from Workbook 0
Userform to Select what worksheets to print 1
Copy .Areas.Item(1,2,3,4,5, etc.) to a column or a row 5
Macro in one workbook that names a range in a different workbook 2
Identify User Selected Range 3
How to identify Chart Source data as range? 3

Back
Top