Range Calculation VBA

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.