advise calculation is complete

R

Ross in Oz

Make a nominated cell turn RED during calculation period and GREEN when all
complete.
My calculation is very large with alot of "IF" fuctions takes 20+ seconds.
 
R

Ross in Oz

I tried this with little success.
I have set Options to "Auto" calculate and I think this Fuction is for
"Manual" only
Ross
 
J

JLatham

You could be right, I may have misinterpreted the last paragraph below both
sets of code to mean that neither would work in Manual calculate mode, but
looking at the first paragraph above the code, it hints that it works in
Manual mode.

I'll keep nosing around - but while you can detect when either the workbook
or a worksheet BEGINS calculation, there's not a ready way to find out when
it quits in automatic mode.
 
R

Ross in Oz

Did you find anything nosing around?
Ross

JLatham said:
You could be right, I may have misinterpreted the last paragraph below both
sets of code to mean that neither would work in Manual calculate mode, but
looking at the first paragraph above the code, it hints that it works in
Manual mode.

I'll keep nosing around - but while you can detect when either the workbook
or a worksheet BEGINS calculation, there's not a ready way to find out when
it quits in automatic mode.
Click to expand...
 
Top