In addition to what Dave suggested, posting your code would allow others to
make improvement suggestions.

--JP

"Roger" wrote in message
...
I have a set of 5 macros which analyse and finally format data. It starts
with about 5000 records and ends up with around 250. I have one "super"
macro which calls and runs each of the other macros in turn, ie

Application.CutCopyMode = False
Application.Run "Agenda.xls!SortDossierOrder"
Application.Run "Agenda.xls!DeleteDuplicates"
Application.Run "Agenda.xls!DeleteExtraRows"
Application.Run "Agenda.xls!DeleteRecentRecords"
Application.Run "Agenda.xls!DeleteExtraCols"
End Sub

Would it be faster to copy and paste each of these macros into one single
macro ? Is there any way I can suppress the screen during the macro
running to save processing time and make it run faster ... it has to sort
through each of the records 4 times and you can see it on the screen
working ? I am using Excel 2002 sp3 on XP

Thanks .. Roger