| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Name in Sequence
Hi friends,
Again an interesting topic! I have three default sheets in workbook "Sheet1", "Sheet2", and "Sheet3". I insert one sheet and renamed it to "MySheet". Now If I insert any sheet then by default I want its name as "Sheet4" not "Sheet5". If its possible then we can even extend it for "Delete" instead of "Rename". Is there any standard way to do this other than looping through "Worksheets" collection and then string comparison? With Best Wishes & Regards, Vinit |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Worksheet Name in Sequence
I don't think so.
In article .com, "Vinit" wrote: Is there any standard way to do this other than looping through "Worksheets" collection and then string comparison? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sequence of cell calcultation in a worksheet | Excel Discussion (Misc queries) | |||
| Consolidation Worksheet Data Sequence. | Excel Worksheet Functions | |||
| Faster way to duplicate worksheet with sequence ??? | Excel Discussion (Misc queries) | |||
| VBA to consolidate multiple worksheets to 1 worksheet in running sequence | Excel Programming | |||
| VBA to consolidate multiple worksheets to 1 worksheet in running sequence | Excel Programming | |||
![Vinit[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
