| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Loop till value changes
I am making a code in visual basic that has to loop till the value in column
C changes. But I don't know how I can put in the code "loop till value in column C changes". Would be great if someone could help me! Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Loop till value changes
i = 2 Do While Cells(i, "C").Value = Cells(i - 1, "C").Value i = i + 1 Loop on exit, Cells(i, "C") will point at the changed cell -- __________________________________ HTH Bob "Ruben" wrote in message ... I am making a code in visual basic that has to loop till the value in column C changes. But I don't know how I can put in the code "loop till value in column C changes". Would be great if someone could help me! Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Loop till value changes
Bob, thanks for your reaction!
Ruben "Bob Phillips" wrote: i = 2 Do While Cells(i, "C").Value = Cells(i - 1, "C").Value i = i + 1 Loop on exit, Cells(i, "C") will point at the changed cell -- __________________________________ HTH Bob "Ruben" wrote in message ... I am making a code in visual basic that has to loop till the value in column C changes. But I don't know how I can put in the code "loop till value in column C changes". Would be great if someone could help me! Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looping till value is 1? | Excel Discussion (Misc queries) | |||
| Calculate numbers till 60 | Excel Discussion (Misc queries) | |||
| Auto update till...... | Excel Discussion (Misc queries) | |||
| SUM C IF B=Cap... Till Next B=Cap... | Excel Worksheet Functions | |||
| SUM C IF B=Cap...TILL NEXT B=Cap... | Excel Worksheet Functions | |||
Linear Mode
