| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic increment of onTime
Thanks OssieMac.
"OssieMac" wrote: Hi yet again Rob, My apologies for the previous version. Was not thinking clearly. The following method of including the date should handle going past midnight also. However, the code is untested in conjunction with the OnTime function. Start time can be real first time because not incremented until after first iteration. Sub test() Dim i As Long Dim timeStart As Date Dim timeIncrement As Date timeStart = Date + TimeValue("17:28:00") timeIncrement = TimeValue("00:01:00") For i = 1 To 370 Application.OnTime timeStart, "CopyVolume" & i timeStart = timeStart + timeIncrement Next i End Sub -- Regards, OssieMac |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find %ontime & SUMIF ontime ie: find matching sets within Range... | Excel Worksheet Functions | |||
| stop automatic increment of dates | Excel Discussion (Misc queries) | |||
| Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions | |||
| How do I input for an automatic increment in a cell on Excel? | Excel Worksheet Functions | |||
| automatic counter or auto-increment | Excel Programming | |||
Threaded Mode
