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

tonywatsonhelp

Well-known Member
Joined
Feb 24, 2014
Messages
3,210
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
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
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
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
 
Upvote 0
It always helps when you have questions about your code if you were to show us your code.
 
Upvote 0

Forum statistics

Threads
1,223,909
Messages
6,175,312
Members
452,634
Latest member
cpostell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top