Is there a way to take a range (say: A7:S10000) and determine what the
current sort order is? I have a userform that allows the user to select which
column they wish to sort by but would like to display on the user form what
the current sort by column is. The columns I allow the user to sort within
the range indicated above is B,C,D,E,G,H,I,P,Q,R

Thanks,

ADK

Using Excel 2000 and beginner at vba