AutoCalculate

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.
 
D

Dick Kusleika

LC

Application.Calculation = xlCalculationAutomatic

I don't know about the second question.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to cut a paragraph that's followed by a table 2
Autocalculation on file open 3
Populate a table based on check box status 2
Autocalculation settings when multiple spreadsheets open 2
Page Cut 1
MMULT( ) 0
AutoCalculate and UDF 6
ASK Field Formatting 1

Top