Activate vs Select

Understanding the difference between Selecting and Activating

There is very little difference between activating a worksheet and selecting a worksheet.
The following means that worksheets "Sheet 1", "Sheet 2" and "Sheet 3" are all selected

Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select 

When more than one worksheet is selected the first worksheet is always the active worksheet.

You can only ever activate a single worksheet.


Cannot activate different worksheets when several are selected

The first line will select three worksheets and by default the first worksheet will be the active worksheet.

Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select 

The second line will not keep the current selection but will infact just select the "Sheet2" worksheet.


This is different functionality to the Select and Activate when using a Range object.

ActiveSheet.Previous.Select ?? 

© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext