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 ***

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" wrote in message
...
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 ***

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 ***