Re-execute all UDF programmatically

[Guest]

Hi,

I'd like to know how I can loop through all Formula / UDF in all worksheets
in a workbook programmatically? Do SpecialCells be useful here? Do the
returned Ranged (by SpecialCells) contains multiple range?

TIA.

 

[Guest]

Thanks Gary, is there a way to loop and touch every formula throughout the
workbook? I want to make sure all formulae are touched, under my certain
criteria .

Thanks,

 

[Charles Williams]

You need to use Application.Calculatefull not sheet.calculate.

see http://www.decisionmodels.com/calcsecretsh.htm for more details on using
the various calculate methods from VBA.

see also http://www.decisionmodels.com/calcsecretsj.htm for advice on
writing UDFs.

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com