Disable calculations to speed up Macro

L

leerem

I have a fairly large spreadsheet, that takes a long time to run due to the
number of times it re-calculates.
Is there any way i can using code, disable the calculation at the start of
the routine and then re-enable at the end?

Regards
Lee
 
M

muddan madhu

Application.calculation = xlcalculationmanual

your code

Application.calculation = xlcalculationautomatic
 
B

Bob Phillips

Application.Calculation = xlCalculationManual

....your code

Application.Calculation = xlCalculationAutomatic
 

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

How to enable / disable re-calculation option? 3
Adding a chart to large workbook brings workbook activity to a hal 6
Speeding up workbook calculations 1
Excel 2003 worksheet doesn't auto calculate 4
macro to insert rows 1
Excel Spreadsheet Calculation Speed and Network Activity 4
Macro that won't go away! 2
Program Speed - Arrays Searching vs. Row Searching 7

Top