Range Calculation VBA

Hello,

I am trying to work out Range Calculation in VBA.

I need to be able to only calculate certain cells within a workbook, and have the rest stay on manul calculation.

I believe this is possible with Range Calculation in VBA but I do not understand how to put the code together

Sheet("").Calculate

Any help would be greatly appreciated.

Regrds,

JC.

You got it.

Sheet1.Calculate ' worksheet code name
Worksheets("someSheet").Calculate ' sheet name
Range("someRange").Calculate ' named worksheet range
SomeOtherRange.Calculate ' range variable

Thanks heaps ! Do I put my sheet name where it says "Sheet1".Calculate

The code name of the sheet -- what you see in the VBE Project Explorer window. In the second example you would use the sheet name that appears on the worksheet tab.