Can anyone help me with this one please? What I want to do is automate recalculating a worksheet say every 5 seconds once it is opened. I have the code Application OnTime Now + TimeValue("00:00:05") but am unsure about how to tie this to the Calculate command and create a loop so that the code keeps running. Thanks in advance.