Do you turn the events back on by setting

Application.EnableEvents = true

at the end of the procedure? This needs to be done otherwise events are off
until you explicitly turn them back on... Post your code.

As for sorting Tom is correct. If you want to sort by Column A then B then C
then D then E then F, just do it in reverse. Sort By F then E then D then C
then B then A. If that does not make sense then just reply.

HTH

"HotRod" wrote:

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