Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sheet numbering system
Generally I wouldn't worry about how they show up in the VBA project window
as long as you're referencing them in code/on worksheets by the names on the tabs themselves. As for what scheme Excel uses to come up with the names - what can I say other than Excel works in mysterious ways at times. "Russ" wrote: I have code that copies a worksheet (like a template but I don't use a template), places it at the end and then renames it. Other code deletes sheets. Everything is working fine but I notice that the sheets are numbered in a strange way. There are only about 40 sheets but in the VBA Project View I see sheets with names like: sheet51(xxxxxx) sheet510(yyyyyyy) sheet52(wwwww) sheet522(zzzzz) How does Excel assign numbers to newly created sheets? Should I just ignore the numbers since over the life of the workbook I will never create more than a few hundred? -- russ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set up a formula for an Alphanumeric numbering system | Excel Discussion (Misc queries) | |||
numbering system | Excel Worksheet Functions | |||
how do I increment a numbering system in excel | Excel Discussion (Misc queries) | |||
Auto Numbering System | Excel Worksheet Functions | |||
Creating a WBS numbering system | Excel Programming |