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 here:

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 here:
>
> 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
> >