SCREEN UPDATE!

[jay dean]

My code executes cleanly, but because it processes a lot of data, the
screen freezes until it finishes all execution.

I want to see the updates while the code is running, so I set
application.screenupdating to true, but it still doesn't seem to help.

Any other suggsetions would be appreciated !

Thanks
Jay


*** Sent via Developersdex http://www.developersdex.com ***

 

[John]

You could add a "DoEvents" line into your loop and see if that helps. It
will slow the process down, but you may prefer to do that and see what's
going on.

Best regards

John

 

[jay dean]

Thanks, John !
I like it. It seems to be working fine. I can deal with the trade-off of
longer execution time.

Thanks again.
Jay Dean


*** Sent via Developersdex http://www.developersdex.com ***