What does 'Sheets("MySheet").Activate' do?

Hi Stan,

The Activate method "activates" the sheet. When a sheet is active, it is the one data will be entered into if you type on the keyboard, and its tab will be white. While many sheets can be selected, only one sheet at a time can be active (this is similar to cells, where many can be selected, but only one in the selected range can be active, i.e., the cell that data will be entered into when you type). Because of this definition it should be obvious that a hidden sheet can never be activated.

I hope this helps.

Damon