VBA to Calculate only a Range or Worksheet (Excel 207/2010 VBA Macro))

The first step is to turn off auto calculations.

Application.Calculation = xlCalculationManual

This code only calculates a certain Range

Range("A1").Calculate

This code only calculates a certain Worksheet Tab

Sheets(1).Calculate

You may want to do this with large workbooks or slow computers to greatly increase speed.

 

Leave a Reply

Your email address will not be published. Required fields are marked *