Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.....
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I name Worksheet Tabs based on some king of reference? Gord Dibben Excel Worksheet Functions 4 August 1st 07 10:52 PM
Sort Worksheet Tabs Beep Beep Excel Programming 3 July 26th 07 06:09 PM
Exporting to ASCII Txt Doc without Tabs [email protected] Excel Discussion (Misc queries) 4 July 14th 07 10:08 PM
Sort Worksheet Tabs BSII Excel Programming 4 February 2nd 07 11:26 PM
Re-Sort Worksheet tabs Campbti Excel Worksheet Functions 1 March 10th 05 05:16 PM


All times are GMT +1. The time now is 12:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"