Speeding up the processes

[chamster]

I have this suspicion that the process i created is going very slowly because one can see every single move. Is it possible to DEACTIVATE the Excel so nothing is being updated to the screen until it's done and ready for presentation? How?

[rory]

Yes - use:

Application.ScreenUpdating = False
at the start of your code and set it back to True at the end.

[chamster]

Great! Thank you very much!