Loop for testing

[kinny2009]

Hi guys,

Just writing a script for testing "J" columns value.

If it's >= 200, then "AV" column show "passed"

But seems like below doesn't work.

Thanks for your help in advance.

Sub a()

Dim i As Long

For i = 1 To Rows.Count

If Cells(i, "J").Value >= 200 Then

Cells(i, "AV").Value = "passed"

End If

Next i

End Sub
()

 

[soadfan]

seems about right, except rows.count

Sub test()
Dim RowsC As Integer
RowsC = Cells(Rows.Count, "F").End(xlUp).Row

For i = 117 To RowsC
If Cells(i, "F") >= 70 Then
Cells(i, "i").Value = "passed"
End If
Next i

End Sub

 

[Rick Rothstein]

seems about right, except rows.count

Sub test()
Dim RowsC As Integer
RowsC = Cells(Rows.Count, "[B][COLOR="#FF0000"]F[/COLOR][/B]").End(xlUp).Row

For i = [B][COLOR="#FF0000"]117[/COLOR][/B] To RowsC
If Cells(i, "[B][COLOR="#FF0000"]F[/COLOR][/B]") >= [B][COLOR="#FF0000"]70[/COLOR][/B] Then
Cells(i, "[B][COLOR="#FF0000"]i[/COLOR][/B]").Value = "passed"
End If
Next i

End Sub

 

[soadfan]

Well i did test in my own file.
I thought he will use his code and will change just counting part, at least this is what i would do

 

[Rick Rothstein]

Well i did test in my own file.
I thought he will use his code and will change just counting part, at least this is what i would do

Probably better to use the references and constants the OP posts in case his/her (or some future reader's) skill level is such that modifying your code might be problematic for him/her.

 

[kinny2009]

Thanks guys, it works

Another follow up-question.

Should i set another rowscount if the "if" function extend to multiple criteria with column "K"

Let's say if "J" column >= 200, and "K" column is "Yes"

Then "AV" column = "passed"

Sub test()
Dim RowsC As Integer
RowsC = Cells(Rows.Count, "J").End(xlUp).Row


For i = 1 To RowsC
If Cells(i, "J") >= 200 And Cells(i, "K") = "Yes" Then
Cells(i, "AV").Value = "passed"
End If
Next i


End Sub

 

[soadfan]

Pick the highest priority column for counting. I mean determine which is the leading column and count only cells in it. So the one count variable is fine

 

[kinny2009]

Hi Soadfun, kind of hard to understand.

Would you please help to modify the code.

Cheers, Bro!

 

[soadfan]

You should count leading column. In this case, it's probably "J" so the code you wrote should do the trick

 

[kinny2009]

It doesn't work

Seems like they cannot read the value in "K" column...