I have a snipet of code that performs a sort for me:

Columns("A:AD").Select
Selection.Sort Key1:=Range("AD2"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

The sort works fine. The person I will be sending this to loves his auto filters, and he will try to use them. The problem is whenever I try and select something from an autofilter, excel undoes my sort. If I sort the data by hand, without using VBA, the sort remains intact. This is most frustrating, any insight? Thanks!