Jim,

Thank you very much for your help!

I used the rFilter.Sort instead of Me.Range("tl_transaction_data").Sort
as you suggested and the sort works. The code does not apply filters on
Activate, it simply allows them to be applied later as needed. So now
when I apply a filter on a column the arrow turns blue as it should.

The range sorted has quite a few columns (transaction entry), and I am
sorting the entire range (transaction = row) based on the transaction
id (number stored in column A), so I'm not quite sure what you mean by
"your sort is sorting rows".

Thanks again,
b


--
bastanu
------------------------------------------------------------------------
bastanu's Profile: http://www.excelforum.com/member.php...o&userid=20015
View this thread: http://www.excelforum.com/showthread...hreadid=395632