Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Worksheet Tabs
I'm using Excel 2003.
I've searched this site and have found sorting tips for worksheet tabs (mainly Chip Pearson's VBA code). However, this ONLY seems to work by assuming the named tabs are ALPHA. What if all 100 of my tabs are numbers??? EXAMPLE: If I have the following tabs labeled: 1, 12, 21, 2000, 350, 3100, 55, 520, 1120, 2500 ...then after running the code I will get the following INCORRECT result: 1, 1120, 12, 2000, 21, 2500, 3100, 350, 520, 55 Is there a way around this? How do I do a NUMERIC sort?? Thanks for any and all help. -- Craig |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Worksheet Tabs
Your answer is in programming, please don't multi post
"Craig" wrote: I'm using Excel 2003. I've searched this site and have found sorting tips for worksheet tabs (mainly Chip Pearson's VBA code). However, this ONLY seems to work by assuming the named tabs are ALPHA. What if all 100 of my tabs are numbers??? EXAMPLE: If I have the following tabs labeled: 1, 12, 21, 2000, 350, 3100, 55, 520, 1120, 2500 ..then after running the code I will get the following INCORRECT result: 1, 1120, 12, 2000, 21, 2500, 3100, 350, 520, 55 Is there a way around this? How do I do a NUMERIC sort?? Thanks for any and all help. -- Craig |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Worksheet Tabs | Excel Worksheet Functions | |||
Sorting Worksheet Tabs | Excel Discussion (Misc queries) | |||
Sorting a range of worksheet tabs A-Z | Excel Worksheet Functions | |||
Sorting Tabs | Excel Discussion (Misc queries) | |||
sorting tabs | Excel Discussion (Misc queries) |