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

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)



"Kevin" wrote in message
...
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

Worksheets are only worksheets; Sheets include Charts, etc.
--
Gary''s Student - gsnu200771


"Kevin" wrote:

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