Autofilter What Column is using Sort Ascending/Descending...

[Jungle Fever]

Dear All,

I am working on this massive spreadsheet at work and as with an earlier post, I would like to know if there is a way either by a Function or a Sub routine to illustrate if a column is sorted in ascending or descending order when using Auto Filter .

I already use Function AutoFilter_Criteria which is informative on a Worksheet but does not illustrate WHAT filter is the primary column being used to be SORT all data in the spreadsheet.

Any help would be appreciated

Thanks