Updating window? 1

[notuserfriendly]

Hi

I'm wondering how to make Excel responding when it's in
a sub or function. I've got a function that is supposed
to handle up to 10 000 items. The problem is not calculating, the problem is that after a while
Excel works kind of a lot and when using other applications at the same time, some things from Excel show.
(happens when there's a lot of items).

I've got some forms that are showing the progress and updating for every item.Would like to know how to fix it
or at least see if it can be less heavy.

 

[PHV]

Have you tried to play with the DoEvents function ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886