Do Loop question
Posted on 2013-12-23
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
Cells(i, 30).Value = "Manual Jnl - 1532952/jwils2 - REVERSE OPENING STD JOURNAL & 1646037/ikass - EUC - MONTHLY EIR POSTINGS FOR FV HEDGE STRUCTURES DE-DESIGNATED"