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.