Status Bar Calculating Cells 50%

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 ?
 
C

Chip Pearson

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)
 
T

Tom Ogilvy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top