Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Dim i As Integer

Sub Module1()
For i = 0 To 100
Cells(67 + i, 2) = Range("O13").value
Cells(67 + i, 3) = Range("P13").value
Sleep 5000
Next
End Sub



O13 and P13 and numbers that are constantly changing, and i want to record the value of those cells every few seconds. When i run this though, they stop updating.

I bet it has something to do with the sleep function eh?