Cool, thanks for the directon Keith74,

Either of these now works fine for me,

Worksheets("Sheet1").Range("B1:b10").Calculate

Range("MyNamedRange").Calculate 'Note:, can be a non-contiguious range

Vaya con Dios,
Chuck, CABGx3



"Keith74" wrote:

Have a look at the Calculate Method in the VBA help, you can set it to
run on a workbook, single worksheet, or specified range.

hth

keith