Full Calculation not doing its job?

  • Thread starter Thread starter rob nobel
  • Start date Start date
R

rob nobel

In This workbook code I have ...
Application.Application.CalculateFull
to force calculation on a wkbk.
I notice that when the wkbk is open that it still shows Calculate in the
status bar
and so I also have to put...
Application.Calculation = xlCalculationAutomatic
before the Calculate will disappear.
Anybody know why?
Rob
 
Checked it out Dave, but seems to be lacking a satisfactory explanation as
to why calculate should show after full calc done. Never mind. It works by
doing an auto calc after the full calc. I was interested only because I
thought I was doing something wrong.
Thanks,
Rob
 
Back
Top