What is the difference between Worksheets and Sheets?

Jacques

Board Regular
Joined
Aug 24, 2005
Messages
64
Are the words Worksheets and Sheets the same thing?

For example:
Worksheets("Calc").Range("A1:G1").value=0
Sheets("Calc").Range("A1:G1").value=0

Are there any differences or different properties between them? Can they be used synonymously?
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
The SHEETS object is a parent object for:
Worksheets
Chart Sheets

If a workbook has 3 worksheets and 1 chart sheet, in VBA:
Sheets.Count will include both types. 4
Worksheets.Count will include only worksheets. 3

Does that help?
 
Upvote 0
Almost 1:30am here......Worksheets.....for me to hide from my boss in the morning!

Sheets......for me, any minute soon, with a pillow and duvet of course lol

:LOL:
 
Upvote 0
Not really relevant, as you probably will never encounter it.

Sheets collection contains all types of sheets. Although today we only use 2 types of Sheets, Worksheets and Chart Sheets, there used to be 3 more types of Sheets, like Dialog Sheets or Macro Sheets. You may still have in your company old excel files that use them. In that case if you check the Sheets collection you'll seem them all there.

In conclusion

Sheets - collection of the Sheets of all types
Worksheets - collection of Sheets of type Worksheet
Charts - collection of Sheets of type Chart Sheet
 
Upvote 0
/!\ In VBA you should use Worksheets() instead of Sheets() when referencing a sheet from another sheet in a formula. This solved some issues i had, maybe you need to be specific about the sheet type this way.

Not really relevant, as you probably will never encounter it.

Sheets collection contains all types of sheets. Although today we only use 2 types of Sheets, Worksheets and Chart Sheets, there used to be 3 more types of Sheets, like Dialog Sheets or Macro Sheets. You may still have in your company old excel files that use them. In that case if you check the Sheets collection you'll seem them all there.

In conclusion

Sheets - collection of the Sheets of all types
Worksheets - collection of Sheets of type Worksheet
Charts - collection of Sheets of type Chart Sheet
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,048
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top