View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BVinson BVinson is offline
external usenet poster
 
Posts: 5
Default Sort worksheet tabs based on ASCII values.

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.....