Status Bar Calculating Cells 50%
 

Excel calcultes how many calculations are on the sheet
and when it does a recalc displays at the bottom of the
screen the status, e.g. calculating cell 5%, 10% etc...

Is there any way to get at these numbers in code ?

Status Bar Calculating Cells 50%
 

Neil,

I don't believe there is any way to determine Excel's calculation progress.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Neil" wrote in message
...
Excel calcultes how many calculations are on the sheet
and when it does a recalc displays at the bottom of the
screen the status, e.g. calculating cell 5%, 10% etc...

Is there any way to get at these numbers in code ?

Status Bar Calculating Cells 50%
 

No, I wouldn't think so; while excel is calculating, your code is suspended.
That may not be true of a UDF that is being calculated by the calculation
engine. You might have your UDF read the statusbar - I have never tried
that.

--
Regards,
Tom Ogilvy


"Neil" wrote in message
...
Excel calcultes how many calculations are on the sheet
and when it does a recalc displays at the bottom of the
screen the status, e.g. calculating cell 5%, 10% etc...

Is there any way to get at these numbers in code ?