View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Ring Dave Ring is offline
external usenet poster
 
Posts: 20
Default Sorting Algorithm required!

I forgot to answer your last question. I find that I can use colons as
statement delimiters (at least in Excel 2001 VBA). You can put the
statements on separate lines to be safe.

I must have a commented version of these sorts somewhere. I'll take a
look and post it if I find it.

Dave

agarwaldvk wrote:

Hi Dave

I am just going through the Radix sort algorithm and I am bit stumped
here!

Could you please the following couple of points before I go ahead with
my attempts to understand how the thing works :-

1. Is this on the assumption that the option base for arrays is to be
set to 1.
2. Are the LO and HI variables the indices for the first and last
strings to sort. In other words are these supposed to be 1 and the
count of the strings to sort.
3. What is the idea of setting LS, RS and DS arrays from 1 to 500? Is
there any specific reason to set them from 1 to 500? Further, are these
always supposed to be between 1 and 500 or are these supposed to be from
1 to the count of strings to be sorted?


You got to be a genius. Gee, this code looks so small but boy is it
complicated or maybe I am probably not good enough???


One last thing, is the colon (2 vertical dots - couldn't show it here
since it converts to the smiley symbol) a valid statement delimiter in
VBA code?


Best regards


Deepak Agarwal