capturing a cell value at a specific time of day

  • Thread starter Thread starter Thomas Donino
  • Start date Start date
T

Thomas Donino

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?
 
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, _
procedure:="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)
 
Back
Top