VBA TIPS
  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".


| HOME |
Copyright © cellmasters.net - colo's junk room All Right Reserved
Tips and Information about Microsoft Excel|Masaru Kaji aka Colo