The Active Sheet object refers to the worksheet that is currently active.

You should only use Active Sheet if you have a specific need to refer to the worksheet that is active.

hide screen updating excel vba-11hide screen updating excel vba-42

This collection is simply called Worksheets and is used in a very similar way to the Workbooks collection.

To get access to a worksheet all you have to do is supply the name.

In the image you can see that the code name is the name outside the parenthesis and the sheet name is in the parenthesis.

You can change both the sheet name and the code name in the property window of the sheet(see image below).

So far we have been using the sheet name to access the sheet.

The index refers to the sheet tab position in the workbook.

The most common use of the worksheet in VBA is for accessing its cells.

You may use it to protect, hide, add, move or copy a worksheet.

If you are new to VBA then this post is a great place to start.