Hi All........

Can anyone please tell me if there is any possibility of causing a "Recalc"
of only certain ranges within a sheet, or of only the Autofiltered results of
a sheet or only certain sheets of the book by themselves, or any other
limited set of conditions?

TIA
Vaya con Dios,
Chuck, CABGx3

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

Some good information he

http://www.decisionmodels.com/calcsecrets.htm

--
Regards,
Tom Ogilvy


"CLR" wrote:

Hi All........

Can anyone please tell me if there is any possibility of causing a "Recalc"
of only certain ranges within a sheet, or of only the Autofiltered results of
a sheet or only certain sheets of the book by themselves, or any other
limited set of conditions?

TIA
Vaya con Dios,
Chuck, CABGx3

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

Thanks Tom..........

Indeed, good reading

Vaya con Dios,
Chuck, CABGx3



"Tom Ogilvy" wrote:

Some good information he

http://www.decisionmodels.com/calcsecrets.htm

--
Regards,
Tom Ogilvy


"CLR" wrote:

Hi All........

Can anyone please tell me if there is any possibility of causing a "Recalc"
of only certain ranges within a sheet, or of only the Autofiltered results of
a sheet or only certain sheets of the book by themselves, or any other
limited set of conditions?

TIA
Vaya con Dios,
Chuck, CABGx3