Filters - sort state

[Fred]

When I click on a column filter button and select "sort A to Z" the filter
button picture changes to show an up or down arrow indicating that this
column was sorted ascending or decending. I am using Excell 2007; I'm not
sure this applies to previous versions.
Is there a way to interrogate the filter or column to determine if the
column filter is showing the up or down arrow indicating that it is sorted.

Thanks for any help
Fred