Careful, this could tie up your system if you do it to long!!!

open a new work book,
right click and view code
paste this in the window

Sub Clock()

'Create an iteration counter
For i = 1 To Range("b1")

'Recalculate the worksheet
Worksheets("sheet1").Calculate
'Update the worksheet with the latest iteration number
Range("b2") = i

'Increment value of i by i
Next i

End Sub


In cell a1 =now() format to desired time view

in cell b1 enter a number, 5000 would be a good start.

then go to tools-macro-select clock-run.


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=472786