Conditional Recalc

[CLR]

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

 

[Keith74]

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

 

[Tom Ogilvy]

Some good information here:

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

 

[CLR]

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

 

[CLR]

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

Indeed, good reading

Vaya con Dios,
Chuck, CABGx3