Hi thanks for looking!

In some cases of my routines, the excel window turns grey/ unresponsive. Although it is not crashing (..most of the time), I am aware the processor power is being sent to interpret scripts, rather than to the Excel window.

I'm starting to look at streamlining code & would like to avoid this grey screen - especially if there will be others users that are unaware of this.

I currently only use the 
application.screeenupdating = false & application.wait (now + timevalue("00:00:10:))
I am looking into the DoEvents but have a bit of difficulty understanding the effects via the help file.

Would using DoEvents during a loop filling up an array, impact the following code IE - it will continue the rest of the code whilst filling up the array?

Any help on DoEvents / other suggestions for this issue will be greatly appreciated

Thanks!