Turning off Screen Updating and automatic Recalculation while your macros are running can speed things up greatly. Consider that to display things correctly, the spreadsheet may be recalculating.

For such a long data process, you may want to turn on Screen Updating to cause a re-display every 30 seconds or so, to show that things are still processing.