Macro Speed

[TyeReece]

I recently switched from excel 2003 to 2013. The macros I had written before worked extremely fast. Now they are so slow I can only start them when I leave work and hope they are done the next morning. Is there anything I can do? I have inserted the following at the beginning and end of the code and it seems to make no difference.

Application.PrintCommunication = False
Application.EnableEvents = False
Application.ScreenUpdating = False



Application.PrintCommunication = True
Application.EnableEvents = True
Application.ScreenUpdating = True

 

[BobUmlas]

add
Application.Calculation = xlCalculationManual
at the beginning and
Application.Calculation = xlCalculationAutomatic
at the end.

Excel 2013 IS slower that 2003 (and 2007 and 2010).

 

[TyeReece]

thanks I will add these. I know I am late with the conversion to 2013 but these speed change makes it almost unusable.