Status Bar Calculating Cells 50%

  • Thread starter Thread starter Neil
  • Start date Start date
N

Neil

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 ?
 
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 (e-mail address removed)
 
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.
 
Back
Top