I keep getting a phantom breakpoint on the same line, but not on every time the loop hits it. I tried clicking Debug > Clear All Breakpoints I've tried copying it to a text editor, running the code without the function existing in it, copy pasting some other data to clear the clipboard (just in case VBA is hiding something), and then copying from the text editor back to the VBA editor
I can't get it to stop stopping on the Set c = Range("l1:l65000").Find(what:=findstring) line.
Sub DeleteRows(findstring As String)
Dim c As Object
Set c = Range("l1:l65000").Find(what:=findstring, lookat:=xlWhole)
While Not (c Is Nothing)
c.EntireRow.Delete
Set c = Range("l1:l65000").Find(what:=findstring)
Wend
End Sub
How do I get rid of this breakpoint?