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.

Please Login or Register  to view this content.

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.