Expanding of a existing Macro

[Yuenk]

The current macro only works on one column. I need it to work with two columns now. When columns O and Q both have a value of zero I want the the correspoding cells in column M to have the value of Canceled. Thanks for any help.

Sub Filling_In_Canceled()
Application.ScreenUpdating = False
For i = 1 To Cells(Rows.Count, "O").End(xlUp).Row
If Cells(i, "O") = "0" Then Cells(i, "M") = "Canceled"
Next i
End Sub

 

[Smitty]

If Cells(i, "O") = 0 And Cells(i, "Q") = 0 Then Cells(i, "M") = "Canceled"

HTH,