| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generic Sheet Names
I'm creating a spreadsheet with a macro to consolidate the data on individual
worksheets. The spreadsheet will be used as a template and copied as required for different scenarios; the worksheets will then be renamed for specific part numbers. Is there a way I can identify the worksheets with their generic names (Sheet1, Sheet2, etc.) in the Visual Basic code of the macro so they will still work even when the individual sheets are renamed? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
| Generic Worksheet Names | Excel Discussion (Misc queries) | |||
| Cell names = sheet names | Excel Worksheet Functions | |||
| I want to print out the sheet tabs (sheet names) | Excel Worksheet Functions | |||
| return all worksheet tab names and chart sheet tab names in report - an example | Excel Programming | |||
Threaded Mode
