application.statusbar fails to update

[baitmaster]

I regularly use application.statusbar to report my progress through long complex loops of code

On most occasions, it gets to a point and then stops reporting: it will stop and just say e.g. "progress = 5%". The macro is continuing in the background, and hitting escape can be enough to force the statusbar to update again - but this can also interrupt the routine

What can I do to keep the statusbar updating correctly?

thanks

 

[BrianExcel]

It's hard to tell without seeing your code, but my first suggestion would be making sure the code to update the status bar is in the right location(s).

 

[baitmaster]

Thanks Brian

The code itself is any loop containing this code. e.g.

totalCells = rng.cells.count
for each cl in rng
    thisCount = thisCount + 1
    application.statusbar = format(thisCount/totalCells,"0.0%")
    ' a series of other calculations and algorithm steps here
next cl

Some of the algorithms I create are quite complex, and may require fairly heavy calculations. I think there is also correllation between switching calculations off and the statusbar failing to update (after a certain point; it updates for the first few seconds, sometimes all the way through)

The issue is simply that, although the calculations and algorithms continue, the statusbar stops updating. I'm wondering if adding a very slight delay is the answer, as maybe it allows the statusbar to "catch up" - but I don't want to slow my code down