Is there a way to reference the current cell range selected?
For example the following statement select the range A1:B3
Range("A1:B3").Select
However, if I select cells A3: B5 is there a command to set the selection in
VB to that range without specifically indicating the cells. So I highlight
cells A3:B5 then I would like to set that as the range selection and then
perform some actions on that range, then highlight another range of cells and
do the same set of actions.