The comparison is coded thusly:
-------------------------------------------------------------
If .Cells(rowNum_FirstData, mySortCol).Value _
< .Cells(rowNum_LastData_Revised, mySortCol).Value Then...
-------------------------------------------------------------


But it's case-sensitive.

To wit:
------------------------------------------------
?("aaa" < "zzz")
True

?("aaa" < "Zzz")
False

?("aaa, ABN AMRO Bank" < "Yorktown Capital LLC")
False
------------------------------------------------


Basically, I want to determine whether a column is in ascending
or descending order so I can sort it to the opposite order.

My kneejerk is to Dim a couple of strings, uCase the values
in question into them, and then do the comparison on
the Dim-d strings.

Is there a good-right-and-holy path to follow here?
--
PeteCresswell