Placing a stop in code for debugging 1

[vba317]

I have a loop that is not working correctly. I need to put a stop so I can debug it is there a way of doing that?

For R3 = 1 To Range("G" & R2) > 0
        If Range("H" & R3 + 1).Value = 0 And BUY1 < BUY2 Then Range("J" & R3).Value = ("Buy at " & Format(BUY3, "0.00") & " or less")
        
         Next R3

 

[SkipVought]

Just use a BREAK. See the Debug Menu Break Icon.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[HughLerwill]

or see VBA help for the Stop Statement.

 

[combo]

You can check the loop range too. You loop to ]b]Range("G" & R2) > 0[/b], which can be either True or False. In both cases the code inside loop does not execute.

combo