listi.net

Sheets Collection

The Sheets collection allows you to do things with sheets. A collection is a group of objects that you might want to process.

If you want to learn more about sheets go here

Go to the Immediate_Window and try the following:

? sheets.count

sheets.add "xyz"

? sheets(0).name

sheets.select

sheets(0).visible = False

Sheets(0).visible = True

You can process all Sheets by



For each sh in Sheets

  Debug.Pring Sh.Name

Next