| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to sort worksheets
Thank you both...Tom's worked fine...thanks again
"Dave Peterson" wrote: Another option would be to rename your existing worksheets using a format like: yyyy-mm-dd XXX ###" XXX You may want to make sure that the inches portion includes enough characters for the worse case scenario: So for example: 2006-01-28 CSB 001" RCP jnf40 wrote: I have tried Chip Pearson's sorting codes and I can't get it to work on my worksheet names, maybe it can't be done... My worksheet names are created by code...the names are as follows: 01-01-06 CSB 18" RCP; 01-01-06 CSB 18" RCP (2); 12-01-05 CSB 18" RCP after the sort I would like the order to be: 12-01-05 CSB 18" RCP; 01-01-06 CSB 18" RCP; 01-01-06 CSB 18" RCP (2)... Can this be done? -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort Worksheets (without VB) | Excel Worksheet Functions | |||
| Sort worksheets | Excel Programming | |||
| Sort Worksheets | Excel Worksheet Functions | |||
| Sort Numerically Worksheets via VB when creating a new worksheets | Excel Programming | |||
| HELP sort 2 worksheets | Excel Programming | |||
Threaded Mode
