Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need a function that I can call to sort sheets in ascending order left to
right, but NOT using DOS logic. I need conventional sort order. For example, the following sheet names would be sorted as follows using a regular sort routine: 1 Sheet 2 Sheet 20 Sheet 200 Sheet 3 Sheet Sheet 6 Sheet 60 Sheet 700 Sheet 8 I need them sorted alpha and numeric; numbers may be at the beginning, middle or end of the sheet name. Can someone please help by posting a function that will handle this? Thanks much in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
sort non delimeted non fixed width alpha numeric column | Excel Discussion (Misc queries) | |||
if able, how do you sort Tabs in excel (alpha-numeric) ?? | Excel Worksheet Functions | |||
Alpha Numeric Sort | Excel Discussion (Misc queries) | |||
Can I change the sort order to Alpha before Numeric? | Excel Discussion (Misc queries) |