worksheets the collection

[lezawang]

Hi
The + sign in the sheet tab that is used to add a new sheet, is it the Worksheets "Collection" object in VBA? Thank you.

 

[MARK858]

As far as I know it just adds a worksheet, AFAIK it can't add a chart sheet or a macro sheet so no it isn't the collection.

BTW it isn't the Worksheets Collection, it is the Sheets Collection.

 

[MARK858]

Actually strictly speaking there is a Worksheets collection but the only purposes I have ever found for it is for preventing errors when looping and you have a mixture of Chart sheets and Worksheets (and the other sheets in the old days) and the placement/adding/Index of worksheets etc.

The + button still as far as I know can only add a worksheet.