Automation help!

This i hope is a simple explanation of a problem i have difficulty finding a solution for on google.

in a cell i have =now() and it shows me the current time/date

ok

if i hit F9 it refreshes or calculates the sheet and updates that cell with the current time when i hit it.

so

how in the $%#$ can i automate me hitting F9 to recalculate or refresh the sheet (so the cell can be up to date) every 10 secs 30 sec...whatever.

will i use a macro that loops or vba somehow.

i thought this would be easy to find a solution however i guess i suck at research.............please help

Hi

Say your formula is in A1.

Enter the code below into a general module and run.

Please Login or Register  to view this content.

This will force a recalculation every 10 seconds.

HTH

rylo