F9

[Aaron Russell]

is there anyway to get excel to constantly act like f9 is being pressed?

 

[Jamie]

Click on Tools, Options, then under Calculations, select Automatic

 

[CarlosAntenna]

tools/options/calculation/automatic

 

[Aaron Russell]

anyway to do it faster. I would like it so it acts like f9 is being pressed
every second.

 

[Don Guillett]

why?

 

[Jamie]

Do you want Excel to automatically calculate formulas? In otherwords, when
you type in a new value, your formula gives you a new result?

If so, then that's what the Automatic option does for you.
Otherwise, maybe you could explain what your desired result is a little more
clearly.

J-me

 

[Aaron Russell]

I have a calculation that shows how many seconds it is until a current
date.. basically it's like a countdown. It shows how many seconds from
right now until december 31, 2004. I would like it to constantly countdown
while I have the spreadsheet open. If you need anymore details I'll post
them. thanks for all your replys.

 

[Harald Staff]

This is a macro. It has to run.

Sub RunClock()
If Cells(1, 1).Value <> "" Then Exit Sub
Application.Calculate
Application.OnTime (Now + 1 / 86400), "RunClock"
End Sub

It stops the second A1 is not empty.

HTH. Best wishes Harald