How can I aviod excel screen turning white and saying not responding?

[tonywatsonhelp]

Hi Everyone,

Firstly just looking for ideas I can try out so if you think you can help let me know.

I have a macro that runs great,

its one that takes data one row at a time and finds were to put it on another sheet.

I'm sure you know what I mean when I say it does the

x = 1 to lastrow
code
Next x

Now, i use the application screen updating false.

and when there are 100 rows it runs great, but if there's 1500 rows it still runs but suddenly the screen will go white and it will say not responding in the top.

this makes the document look like its broken and I get a lot of problems people telling me it does not work, how could i avoid this happening?

Thanks

Tony

 

[joeu2004]

Try adding the following line to the For-Next loop:

DoEvents

To avoid increasing loop time significantly, it would be prudent to call DoEvents every n loops. Since 100 iterations "runs great", you might try:

If i Mod 100 = 0 Then DoEvents

 

[My Aswer Is This]

It always helps when you have questions about your code if you were to show us your code.

 

[tonywatsonhelp]

Thanks Joeu2004 this is excellent works great thanks

Tony