Hi Guys, I have a While...Wend Loop that loops down column 5 in a spreadsheet.how do I change the following code to add an Instring to the Loop. If I wanted to Loop down and look for the number "3588343" in a cell in column 5, how would I adapt the following code?
Dim Prevday As String
Dim i As Integer
'Prevday = WorksheetFunction.WorkDay(Date, -1)
i = 4
While Cells(i, 5).Value <> ""
ElseIf Cells(i, 8).Value = "3588343, 3587873" Then