capturing a cell value at a specific time of day
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? |
capturing a cell value at a specific time of day
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? |
All times are GMT +1. The time now is 01:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com