Solved: recalculate a function

[sw21]

Hi,
does anyone know how to recalculate all the function of a workbook with a VBA function? these functions are located in a VBA module and I would like to refresh all the workbook. there are maybe hundred functions spread in several sheets. Some of the functions return an array and should be recalculated with ctrl shift enter ...
thx
swan

[mikerickson]

[VBA]Application.Calculate[/VBA]

[GTO]

I might not be understanding, but have you tried:

Application.CalculateFull

Hope that helps,

Mark

[sw21]

Amazing. Thanks you guy that was helpfull.