If then VB statement

[Guest]

My attempt doesn't work:

If Columns("B:B") = "A" And Columns("N:N") = "manual Calc" Then
Columns("O:O") = "0"

I need it to see if column B has value "A" in it with a matching row of
column N with value "manual Calc" and if true then set the same rows column O
to a value of "0".
Thanks in advance for your expert advice!

 

[Guest]

try this for-next loop.

Sub readcolumns()
For x = 1 To 65536
If Worksheets("Sheet1").Cells(x, 2).Text = "B" And _
Worksheets("Sheet1").Cells(x, 14).Text = "manual calc" Then
Worksheets("Sheet1").Cells(x, 15).Value = "o"
flag = 1
End If
Next
End Sub

Mike

 

[Guest]

Works like magic! Thanks a ton for your help!

try this for-next loop.

Sub readcolumns()
For x = 1 To 65536
If Worksheets("Sheet1").Cells(x, 2).Text = "B" And _
Worksheets("Sheet1").Cells(x, 14).Text = "manual calc" Then
Worksheets("Sheet1").Cells(x, 15).Value = "o"
flag = 1
End If
Next
End Sub

Mike

 

[Guest]

Your welcome and thanks for the feedback.

Works like magic! Thanks a ton for your help!

 

[Stan Lo]

Hi Mike

What does the flag=1 do?

thanks
Slo

Your welcome and thanks for the feedback.