AutoCalculate

  • Thread starter Thread starter LC
  • Start date Start date
L

LC

Hi,

Is there a way to set the autocalculation to true in VBA,
just like going to options and then checking off the
autocalculation box?

I drew a box around my data, but for some reason the box
is cutted off when there is a page cut. Is there a way to
complete the outline of the box despite the page cut?

Thanks.
 
LC

Application.Calculation = xlCalculationAutomatic

I don't know about the second question.
 
Back
Top