View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tom tom is offline
external usenet poster
 
Posts: 570
Default referencing current range of cells selected

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.