Ok, I understand that I can click on a sheet tab with the mouse to activate
it.
Then if I Ctrl-click I can select additional sheets.
Howver letws say we are dealing with just 2 hseets in the workbook.
If Sheet2 is active then the command Sheets("Sheet1").Activate
is the same as clicking on the Sheet1 tab with the mouse.
Does the command Sheets("Sheet1").Select do exactly the same thing?


"JLGWhiz" wrote in message
...
You can select more than one, but only one can be active.

"John Broderick" wrote:

Hello all,

What is the difference between these two:
Sheets("Sheet1").Activate
Sheets("Sheet1").Select

Thanks,
John