View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tim Tim is offline
external usenet poster
 
Posts: 408
Default Variable Problem.

Hi Ron,

When I ran the code with the following str (date), I got the result like
this: 1/1/05, 10/10/05, 12/1/06, 12/15/05 Max Value: 12/15/05. I am
expecting 12/1/06 is the last value but it is not.

str = ("12/1/06, 12/15/05, 1/1/05, 10/10/05")

Please help.

Thanks in advance.

Tim.

"Ron Rosenfeld" wrote:

On Sun, 22 Jan 2006 22:31:02 -0800, Tim wrote:

Hi Ron,

Thank you very much for your code. I have another question regarding the
code. How to sort the alphabet and date? Please help.

For example:

str = ("12/1/06, 12/15/05, 1/1/05, 10/10/05")

or

str = ("Peter Smith, John betz, John bocco")

Thanks in advance.

Tim.



What was the problem with the sort you obtained when you tried those values for
str?
--ron