PDA

View Full Version : Solved: recalculate a function



sw21
02-12-2010, 12:47 AM
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
02-12-2010, 03:34 AM
Application.Calculate

GTO
02-12-2010, 03:44 AM
I might not be understanding, but have you tried:


Application.CalculateFull

Hope that helps,

Mark

sw21
02-12-2010, 08:49 AM
Amazing. Thanks you guy that was helpfull.