Excel uses a persistent sort. You can sort on all 256 columns if you like,
but you have to sort 3 at a time. Start with the least significant to the
most significant.

--
Regards,
Tom Ogilvy



"HotRod" wrote in message
...
I've actually turned of all of the Application.EnableEvents = false code
in
my code, I'm wondering if an error will cause this problem? Is it possible
that an error is occurring that just jumps out of the macro?

One other question I've been googling for an example of how to Sort more
than three columns at a time and depending on where I look some sites say
that it's not possible. This is the code I'm using below.


Range("A" & First_Data_Row & ":AA55550").Sort Key1:=Range(First_Column &
First_Data_Row), _
Order1:=xlAscending, Key2:=Range(Second_Column & First_Data_Row),
_
Order2:=xlAscending, Key3:=Range(Third_Column & First_Data_Row), _
Order3:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom