Macro for recalculating

[muziq2]

Hi all,

I am trying to create a countdown timer. I want the formula t
recalculate at a certain interval. Does anyone know a macro that wil
do this?

Thanks,

Jef

 

[David McRitchie]

You can force recalculation see areas around F9 usages in
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

You shouldn't have any problem downloading clock,
timers, countdown times from the internet that are
more or less dedicated to the one task and would
not interfere with your Excel use, and should be more
accurate not being backlogged within Excel.
http://www.mvps.org/dmcritchie/excel/datetime.htm
which also has some examples of timers / alarm clock
that run in Excel.