Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Loop?
Hi,
With reference to the code below. I would like to loop this code at specific one minute time intervals two cells to the right. The idea is to have the loop running from 10am to 4pm. Assuming for example that cell i6 is the active cell at 10am and then at 10:01am k6 becomes the active cell. Sub CheckVolumeRise2() If Range("i6") < Range("k6") And Range("k6") < Range("m6") Then CriteriaReached.Show End If End Sub So at 10:01am the routine would be checking k6 < m6 <o6. Please will someone show me how to implement this. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
returning back to loop check condition without completing the loop | Excel Programming | |||
Loop to Filter, Name Sheets. If Blank, Exit Loop | Excel Programming | |||
Naming Worksheets - Loop within a loop issue | Excel Programming | |||
(Complex) Loop within loop to create worksheets | Excel Programming | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming |