Hi,
I have created a VBA with the condition whereby if the nos are greater than/equal than 31 and less than/equal to 46, the value will return 1 in column L.
But now, I want to add another condition whereby this will only be apply if column D is AA. Can anyone assist me on how to add that condition below?
![]()
Sub macros() Dim lRow As Long Sheets("COMVERSE").Select lRow = Range("I" & Rows.Count).End(xlUp).Row For i = 2 To lRow If Cells(i, 9) >= 31 And Cells(i, 9) <= 46 Then Cells(i, 12) = "1" Else Cells(i, 12) = "NO" End If Next i End Sub
Bookmarks