(Solved) – VBA to reference currently selected multi-cell range?

  • by
(solved)-–-vba-to-reference-currently-selected-multi-cell-range?

I can post some code, but my question is so simple I don’t think that’s needed. I think I’m just struggling to know what to google.

I want to select (with my mouse) a range of multiple contiguous cells all in the same row and then execute a subroutine that will have a way to reference all the cells in that selected range. Is there a built in method for that? Something like:

Worksheet.ActiveRange(1,1).Value2

would reference the first cell and then

Worksheet.ActiveRange(1,2).Value2 

would reference the second cell.

Leave a Reply

Your email address will not be published. Required fields are marked *