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.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"LC" wrote in message
...
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.