Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

closed as too localized by random Jun 15 '12 at 14:02

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, see the FAQ.

1 Answer

Fixed the problem by rebooting the computer.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.