RE: [ExcelVBA] Sorting

 

Lower case comes before upper case so A-Z then a-z

John. Visio MVP

From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
Of 1z@compuserve.com
Sent: Sunday, January 29, 2012 12:23 PM
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] Sorting

'Lo everyone,

I'm confused.... and having a bad hair day.. Grrrrrrrrr.

A little while ago I wrote asking about sorting.
As part of testing I wrote a random string generator to populate an array.

In a test, two of the string generated were...

S1="Zrfwb49"
S2="nufEktFUjbnhT6u4LQ4PqXKJBxv7JjRTcxYvv44EUgf4M42"

Can anyone please tell me why S2 is > S1 please please please ?????

TIA
Lisa

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (6)

Recent Activity:

• New Members 4

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___