Access worksheets in Excel using names in macros |
|
| Access worksheets in Excel using names in macros to make calculations easier, quicker, less error prone and provide better macro code. You can use the Sheets property in Microsoft Excel to return a worksheet, chart, module, or dialog sheet. The example in the Excel training video activates the sheet named "Expense" in the active Excel workbook. This is easier for programmers than using 'sheet1', 'sheet2' , etc. Sub ActivateExpense() Sheets("Expense").Activate End Sub | |