For this macro, I'm trying to get it to work so that once a user selects multiple cells (A1, C3, F7, etc), the macro selects 100 cells below that so the range is (A1:A100, C1:C100, F1:F100). It does this for however many cells are selected.
This range then needs to be saved for some other use, like plotting. (save it as a variable?)
Is there a simple way of doing this?
I'm thinking of a while loop, but not sure how to implement it for multiple selected cells.
I'm kinda new to VBA, so apologies if this is a too basic a question.
Thanks!
This range then needs to be saved for some other use, like plotting. (save it as a variable?)
Is there a simple way of doing this?
I'm thinking of a while loop, but not sure how to implement it for multiple selected cells.
I'm kinda new to VBA, so apologies if this is a too basic a question.
Thanks!