Sheets and Worksheets
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 |
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 |
Sheets and Worksheets
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 |
All times are GMT +1. The time now is 01:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com