Code Crashes Excel 2010 but works in Excel 2003

Hello,

I have the following code that is crashing Excel 2010. It is applied to a range of cells that contain a column header. When the cell is double clicked it is suppose to sort by that column. Unfortunately, Excel crashes instead. This code works fine in 2003. Any suggestions would be appreciated.

Thanks!

Update: It's only the last sort criteria that crashes Excel. When removed, the macro runs fine and Excel does not crash but with it, Excel crashes. It looks like it runs as all the way through, sorts, and then crashes.

Please Login or Register  to view this content.

You haven't specified Order3 in any of the cases; you specify Order2 twice. Try this.

Please Login or Register  to view this content.

probably this suffices:

Please Login or Register  to view this content.