For Next loop problem
Hi
Is there a limited time a for next loop will run? (not
counted). The end of the data is marked by text "END".
This works fine for small amounts of data, but seems to
exit around 96 samples. If I then re-run it its fine and
exits correctly.
Thanks
Jo
On Error GoTo errhandler
Dim endofdata
For Each cell In Range("results")
Range("O7").Select
endofdata = ActiveCell
If endofdata = "END" Then GoTo errhandler
various stuff here (cells get deleted and moved up)
Next
errhandler:
Exit Sub
|