Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to exit the loop?
Does anyone have any suggestions on how to exit the loop if mycell.Text =""?
When myCell.Text is equal to "", the loop keeps going, but I would like to exit the loop if myCell.Text is nothing or "". Does anyone have any suggestions on how to code it? Thanks in advance for any suggestions Eric Dim myRng As Range Dim myCell As Range For Each myCell In myRng.Cells On Error Resume Next Mywebsite = myCell.Text On Error GoTo 0 ' Perform task Next myCell |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loop to Filter, Name Sheets. If Blank, Exit Loop | Excel Programming | |||
exit for loop | Excel Programming | |||
exit for next loop | Excel Programming | |||
exit from a loop? | Excel Programming | |||
exit from a loop? | Excel Programming |