Sheets and Worksheets

[Kevin]

When and why would I want to use the Worksheets property as opposed to the
Sheets property?

e.g.,

this = Worksheets("Sheet1").Cells(1,1)

or

that = Sheets("Sheet1").Cells(1,1)

Thanks much.


Kevin

 

[Bob Phillips]

When you want to exclude any non worksheet sheets, such as chart sheets.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Gary''s Student]

Worksheets are only worksheets; Sheets include Charts, etc.