Clear contents if 2 different conditions met

[deduwa]

Hi,

I have the below code. Is there a way to edit this so that going down each row of a table, if cells in column I and column S of that particular row are both negative, then clear contents of those particular cells only?

Application.ScreenUpdating = False
For i = 1 To lastRow
If Cells(i, "G").Value = "Delta" Then Cells(i, "S").ClearContents
Next i
Application.ScreenUpdating = True


Note the above code works for a different condition I have in a separate sheet, so ideally don't want to re-create something from scratch.

Thanks

 

[Joe4]

Try something like:

[COLOR=#333333]For i = 1 To lastRow[/COLOR]
[COLOR=#333333]    If Cells(i, "I").Value < 0 And [/COLOR][COLOR=#333333]Cells(i, "S").Value < 0 [/COLOR][COLOR=#333333]Then 
[/COLOR][COLOR=#333333]        Cells(i, "I").ClearContents[/COLOR][COLOR=#333333]
        Cells(i, "S").ClearContents
[/COLOR]    End If
[COLOR=#333333]Next i[/COLOR]