Thomas,

Use OnTime that triggers a macro that captures the value. something like
this which runs the macro after 2 mins (120 secs)

Public dRun As Double

Sub StartTimer()

RunWhen = Now + TimeSerial(0, 0, 120)
Application.OnTime earliesttime:=dRun, _
procedu="mySub", _
schedule:=True
End Sub



Sub mySub()

Range("G3").Value = Range("C3").Value

End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Thomas Donino" wrote in message
...
Can i capture the value of a dynamically updating cell at
a specific time of day(from a linked realtime
spreadsheet)? and if so how do i go about it?