I have a For Next Loop represented simply below:
Do Until Name = ""
Set Name = ActiveCell.Offset(i, -1)
'ActiveSheet.Cells(ActiveCell.Row + i, ActiveCell.Column)
If WorksheetFunction.CountIf(NameList, Name) = 0 Then
MsgBox "Name Not in Database"
Test = NameBlotter(Name, TradeDate, NameList, SharesTraded,
Answer = NameBlotter(Test, i)
i = i + 1
I have a test condition represented by the If Then statement above. If it
is true, A message box appears, then upon user input, the macro exits the
I would prefer that after the conditional is true, it will skip to "i = i
How can I do this?