Store selected rows, then pass the row range to a With For Loop.

Rather than have the user manually write, "E3:E10", for the following block of code:

Please Login or Register  to view this content.

I would like VBA to read the range of cells stored when a user, uses their mouse to select E3:E10 on the worksheet. From there I'd like to pass it with CStr, if necessary, into the argument of 'For Each cell In Range'

The following statement, is only capable of recognizing one cell at a time, and it doesn't store the absolute cell location, i.e. E3, but the displayed value.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I'd like "E3:E10" to be displayed; to let me know the previous statements are working as intended.

The following worked, .Address had to be included:

Please Login or Register  to view this content.

If one could tell me how to retrieve, or store "E3:E10" when a user selects these 7 cells with their mouse, it would be appreciated..