advise calculation is complete

  • Thread starter Thread starter Ross in Oz
  • Start date Start date
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.
 
I tried this with little success.
I have set Options to "Auto" calculate and I think this Fuction is for
"Manual" only
Ross
 
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.
 
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...
 
Back
Top