Ideas / advice using DoEvents or similar functions to streamline code & avoid greyscreen

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

Please Login or Register  to view this content.

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!

DoEvents will make your code slower. Look at increasing the efficiency of your code rather than dealing with the symptoms of it being slow.

If you can post your code, we can offer suggestions as to how to make it quicker

Hi thanks,

I've narrowed down the area that seems to be giving the worst grey screen issues. There's some looping that's pretty hard to follow - I've noted the part in bold below, which is the only area that really affects it.

-There is an input box entry for data that is missing,
- whist checking its empty, it also holds and a value from an adjacent cell.
- If this adjacent value is matched on the next empty cell, it automatically fills it with the data already put in by the user from the input box (held in dim HLD & POt)

This could fill up to 500 cells at a time which I think is creating the giving grey screen

Any ideas with this I would be very thankful!

(The j and jt dimensions is just a count issued prior to running this loop - all it does it give the use an indication of how many entires need to be filled and the -1 is counting down)

Thankyou!

Please Login or Register  to view this content.