| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheets.Add Function
Is there any way to tell a macro that when a new sheet is added what the
sheet name is instaed of having Excel just give it the next "sheet1"? Other functions in the macro reference the newly created tab and I'll never be able to ensure it is ALWAYS "sheet1" before running the macro. I would like to have the macro automatically give it a name I designate. "Sheets.Add" is the function. Any ideas?? Frank |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indirect function across sheets | Excel Discussion (Misc queries) | |||
| find and add function between sheets | Excel Discussion (Misc queries) | |||
| A function to create new sheets | Excel Discussion (Misc queries) | |||
| Sheets Tabs Function | Excel Programming | |||
| Create a function between sheets | Excel Discussion (Misc queries) | |||
Threaded Mode
