Not much to work with but, in general if you are running macros that the recorder has written for you then you may want to try a couple of things.
1. Get rid of all select statements that select ranges or sheets. Example:
The recorder will give you:
this can be changed to:
2. Turn off screenupdating and calculation during macro. Example:
**Application.ScreenUpdating = False
**Application.Calculation = xlCalculationManual
**' Your code here...
**Application.Calculation = xlCalculationAutomatic
**Application.ScreenUpdating = True
3. Lastly the one thing that admittedly I'm not very good at is to avoid loops in your macro.
Hope this helps!