veematics
asked on
Excel: Next Iteration with VBA
Is there any way to skip an iteration in For.. Next Iteration ?
My Script is something like this :
so basically i would like to check a value (in this case empty cell), if its true than skip the iteration to next value
My Script is something like this :
For i = 2 To TotalRows
If Selection.Offset(i - 1, -7).Value = "" Then
Next i
End If
[commands goes here]
Next i
so basically i would like to check a value (in this case empty cell), if its true than skip the iteration to next value
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
So in IF condition, I have converted '=' sign to '<>' sign.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.