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

  • by

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:


would reference the first cell and then


would reference the second cell.

Leave a Reply

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