Determine if a worksheet is sorted
 

Is there any way (property or otherwise) in VBA to determine if a worksheet
is already sorted, and if so, what the sort key(s) is/are?

--
Message posted via http://www.officekb.com

Determine if a worksheet is sorted
 

Not that I know of. You could write a macro to loop through all the
columns, and in each column, loop through all the cells and determine by
brute force if that column is sorted either ascending or descending. That
would be an indicator that the data is sorted by that one column, but even
that is not foolproof. HTH Otto
"Fox via OfficeKB.com" <u18899@uwe wrote in message
news:5fc322b87ff94@uwe...
Is there any way (property or otherwise) in VBA to determine if a
worksheet
is already sorted, and if so, what the sort key(s) is/are?

--
Message posted via http://www.officekb.com