I have some vba that loops through a few hundred rows and finds the first instance of a name in column 1, but I then want it to carry on looping until it finds the first instance of a zero value in column 4, while still retaining the name value in column 1.
If I haven't confused you with my grammar, could you please point me in the right direction?
The code is this;
For x = 2 To lr
If ws1.Cells(x, 1) = Me.cboChildFullName And ws1.Cells(x, 4) = 0 Then
ws1.Cells(x, 4) = ws2.Range("TimeNow").Value
ws2.Range("KidsPresent") = ws2.Range("A:A").Cells.SpecialCells(xlCellTypeConstants).Count - 1