Activate vs Select

There is a difference between activating a range and selecting a range.
The following means that the cells "A1:D4" are selected and since "B2" is contained in the cell range "A1:D4" it is the active cell within a larger selection.

Range("A1:D4").Select 
Range("B2").Activate

The following means that the cells "A1:D4" are selected but since "D6" is not contained in cell range "A1:D4", the cell "D6" is then selected.

Range("A1:D4").Select 
Range("D6").Activate

Both methods can only be used to select cells on the active worksheet.



© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top

PrevNext