Thread: How to break the FOR loop?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default How to break the FOR loop?
Believe it or not, the command is...

Exit For

--
Rick (MVP - Excel)



"Eric" wrote in message
...
Does anyone have any suggestions on how to exit FOR loop?
Thanks in advance for any suggestions
Eric

For Each myCell In myRng.Cells
' if wkbk.Sheets("Check").Range("O18").Value = 0 then exit FOR loop
Next myCell

Reply With QuoteReply With Quote