Can anybody explain to me what is incorrect about the following code as I keep getting "Compile Error: Loop without Do" message:
Sub RemoveSalesReps()
'
'Do
DoEvents
row_number = row_number + 1
Z1_Sales_Rep = GTCalc.Range("n" & row_number)
If InStr(Z1_Sales_Rep, "MR X") >= 1 Then
GTCalc.Rows(row_number & ":" & row_number).Delete
row_number = row_number - 1
Loop Until Z1_Sales_Rep = ""
MsgBox "Complete"
End Sub
Bookmarks