What is the difference between the Sheets object and the Worksheets object?


sheets stands for only worksheets object.

worksheets standas for worksheets object but also Dialogue sheets object and Chart sheet object are included.

Example

If you have a workbook as follows,

MsgBox Sheets(1).Name returns "Chart1"

MsgBox Worksheets(1).Name returns "Sheet1".