Simple Loop

[John]

I have data in I4:I18. If the value is greater than zero I would like to
check if the value in V & activerow (ex: V4) is greater than I & activerow.
If so, do command and keep checking the remaining rows.

 

[Mike H]

John,

Try this

Sub sonic()
For Each c In Range("I4:I18")
If IsNumeric(c.Value) And c.Value > 0 And c.Value > c.Offset(, 13).Value
Then
'Do something"
End If
Next
End Sub

Mike

 

[Jacob Skaria]

Try

Sub Macro()
For Each c In Range("I4:I18").Rows
If Range("V" & c.Row) <= c.Value Then
'Do somthing. Number in V less than I
End If
Next
End Sub

If this post helps click Yes

 

[John]

I am getting the command run (the do something part) run 16 times... How do I
check that row once and then move to the next row?

 

[John]

nevermind got it...

I am getting the command run (the do something part) run 16 times... How do I
check that row once and then move to the next row?