[RESOLVED] Loop Debugging Issue

[JonnyPoet]

Yes, an If statement within the loop like

If i = 8000 Then
  debug.print i
End If

Yes this is the way to stop at a defined point.
Your whole code would look like

Public Function RemoveAll() As Boolean
Dim i As Integer, last As Integer
last = mCol.Count
For i = 1 To last
   if i = 8000 then
     Debug.print i
   end if
   mCol.Remove 1
Next
End Function

And set F9 at the shown brown line