Formulas & Screen Updating

  • Thread starter Thread starter sa
  • Start date Start date
S

sa

Through VBA I want to place a large number of formula in Excel without it
calculating the formula and also updating the screen. Is there a way to turn
off the calculation of all formula while you are doing this and screen
updating.

You can use

application.screenupdating=false

but when you place the formula in the cell Excel updates the screen.

How can I get over this?
Is there a global variable to turn off both screenupdating and
recalculation?

Thanks for any help
 
Sure.

Application.Calculation = xlCalculationManual
'
Application.Calculation = xlCalculationAutomatic

HTH. best wishes Harald
 
Herald

Sorry, meant to include this option but we still have the same issue. We did
turn calculation to manual.

Regards
 
You must log in or register to reply here.

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

Excel 2007 average formula 3
Screen updating and formulas 2
Screenupdating 1
Screen update or visible? 4
date in excel 16
Formulas Not Recalculating Automatically 1
Excel out of resources - help ! 4
Labels in Formulas requires manual refresh? 2

Back
Top