StefanRSA
New Member
- Joined
- May 26, 2008
- Messages
- 24
Hi Guys,
Im trying to go through a list of names, find the blank one, then add a name into it. I tried using a FOR loop but it keeps adding for every blank all the way down the list, not just the first one.
Any advice on how to exit the FOR loop when the IF statement is TRUE? Or perhaps a different method to achieve the same end?
For x = 10 To 209
If Cells(x, 2) = "" Then
Cells(x, 2).Value = Employee
End If
Next
Many thanks in advance,
Stefan
Im trying to go through a list of names, find the blank one, then add a name into it. I tried using a FOR loop but it keeps adding for every blank all the way down the list, not just the first one.
Any advice on how to exit the FOR loop when the IF statement is TRUE? Or perhaps a different method to achieve the same end?
For x = 10 To 209
If Cells(x, 2) = "" Then
Cells(x, 2).Value = Employee
End If
Next
Many thanks in advance,
Stefan