Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am going to try to explain a little better here what I am trying to do....
As an example my worksheet has: |VFD11 | VFD2| VFD1 | VFM45 | VFM43 | VFM2 | ( "|" indicates new tab) 1 2 3 4 5 6 So my firstGroup integer would be 3 (it stopped sorting the VFD worksheets on tab 3). My secondGroup integer would be 6. Now I need to sort the first section/group which are the tabs VFD11 through VFD1, in ascending order. So I know I need to compare 2 sheets at a time, from 1 to firstGroup (3)...but to do it enough times to sort all of the worksheets...so I believe that is (n-1) times.... But to compare the sheets I have to have another for loop to loop through and get the total ascii values for the first worksheet and the one I am comparing it to...then I have to compare the ascii values and if the first sheets' value is than the one I am comparing, swap them.... I have to do this for each section.... Hope this helped to clarify my problem..... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I name Worksheet Tabs based on some king of reference? | Excel Worksheet Functions | |||
Sort Worksheet Tabs | Excel Programming | |||
Exporting to ASCII Txt Doc without Tabs | Excel Discussion (Misc queries) | |||
Sort Worksheet Tabs | Excel Programming | |||
Re-Sort Worksheet tabs | Excel Worksheet Functions |