View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Sheets and Worksheets

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