Sheets vs worksheet
Is there a difference with sheets(1) and worksheets(1)?
Will Name = worksheets(1) (or sheet(1)) give me the name assigned to the worksheet? Is the order of the worksheets the same as the displayed order when the workbook is open? Want to activate and work on first 16 worksheets which plop values into the last two worksheets. I'm using: For n = 1 to 16 Sheets(n).select rada, rada, rada Next It doesn't seem to be working thanks John |
Sheets vs worksheet
John,
The Worksheets collection contains only worksheets. The Sheet collection includes worksheets, chart sheet, XL4 macro sheets, and XL5 dialog sheets. The order of the sheets in either collection is the order in which the tabs appear in the Excel window. You can get the name of the sheet with code like Dim SHName As String SHName = Worksheets(1).Name It doesn't seem to be working In what way is this not working? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "John" wrote in message ... Is there a difference with sheets(1) and worksheets(1)? Will Name = worksheets(1) (or sheet(1)) give me the name assigned to the worksheet? Is the order of the worksheets the same as the displayed order when the workbook is open? Want to activate and work on first 16 worksheets which plop values into the last two worksheets. I'm using: For n = 1 to 16 Sheets(n).select rada, rada, rada Next It doesn't seem to be working thanks John |
All times are GMT +1. The time now is 06:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com