Recalculate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Select Case worksheet function called Holiday: Select Case Date. The cell formula is = Holiday(). If the system date is 1/19/2004, for example, the cell will display "MLK Day.
If there a way when the worksheet loads for the formula to automatically recalculate so that on 1/19/2004, for example, MLK Day would display
Thanks
Howard
 
Hi Howard,

If you make your function volatile (insert Application.Volatile in your
function) then it will recalculate whenever the workbook is recalculated.

If your workbook is using automatic calculation mode
(Tools-->Options-->calculation) then it will be recalculated whenever it
opens.

Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

Howard said:
I have a Select Case worksheet function called Holiday: Select Case Date.
Click to expand...
The cell formula is = Holiday(). If the system date is 1/19/2004, for
example, the cell will display "MLK Day."
If there a way when the worksheet loads for the formula to automatically
Click to expand...
recalculate so that on 1/19/2004, for example, MLK Day would display?
 
Back
Top