Sort direction selection

hi,

I need to find the current application setting for a sort function. is there a way to toggle the way a Sort function use xlDescending and xlAscending.

Please Login or Register  to view this content.

I Know sortorder is not a vba function, but it is the best way to describe it. What i am trying to describe is that i need to find the last sort order and the toggle it to the opposite. Is this possible?

tks,

Hi,

maybe not directly, but you could compare the top and bottom of the range to determine which is larger, and therefore what the current sort order is?

Got it, but in an not very good way.

Please Login or Register  to view this content.

With this code i have to save a variable value to the sheet in order to toggle to the opposite Ascending/Descending value.

Does anybody know if there is a way to retrieve the applications last sort order? would like to get this in a way without having to save the sort order varable value to the spreadsheet.