Progress indicator/Loop help

Hi,

I have put together the following code that duplicates rows and updates a progress bar userform. It works perfectly however the inefficiency of the progress bar code is really slowing down the run time, as the progress bar can update anywhere up to 15000 times. What I'd like to do is either optimise the progress bar calculation or even limit the number of times it refreshes.

A way I thought of doing this is only calling the progress sub every time the percentage complete is a multiple of ten but I'm not sure how the best way of doing this would be, or if there is a much simpler/more efficient method. Any ideas? Thanks

Please Login or Register  to view this content.

Hi,
If you have large number of rows then your "pctCompl" will increase slowly.
You could set some variable, lets say "tempCompl", set some value at the beginning of your code, lets say you wish to change Progressbar after 10% completed. tempCompl = 10.
Then compare this temporary varuable with actual progress.
Something like this

Please Login or Register  to view this content.

Originally Posted by xlnitwit

Hi,

Perhaps something like this

Please Login or Register  to view this content.

Thanks. It does work - sort of. While pctCompl is between 4.5 and 5.4, 9.5 and 10.4 etc, it computes all lines.

Originally Posted by kasan

Hi,
If you have large number of rows then your "pctCompl" will increase slowly.
You could set some variable, lets say "tempCompl", set some value at the beginning of your code, lets say you wish to change Progressbar after 10% completed. tempCompl = 10.
Then compare this temporary varuable with actual progress.
Something like this

Please Login or Register  to view this content.

Cheers, this does seem to be the best option so far.