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