vba.- Looping "if"

[montecarlo2012]

Hello.

Sub TTT()
Dim Y&
  Dim x&
  
  For x = 2 To 9 ''ROWS
  For Y = 13 To 14 'COLUMNS - M & N
    Cells(2, 2).Formula = "=IF(" & Cells(x, Y).Address & "<" & Cells(x, Y).Address & ",TRUE, FALSE)"
    
  Next
   Next
End Sub

Trying to make it work but....
what I have and I expect is

Please, some hand here.
The first column is on M and next N and the results at B.
thanks.

 

[mohadin]

Hi
Try

Sub TTT()
Dim Y&
  Dim x&
  For x = 2 To 9 ''ROWS
    Cells(x, 2).Formula = "=IF(" & Cells(x, 13).Address & "<" & Cells(x, 14).Address & ",TRUE, FALSE)"
  Next
End Sub

Or

Sub test()
Range(Cells(2, 2), Cells(9, 2)).Formula = "=IF(M2<N2,TRUE, FALSE)"
End Sub

Or

Sub test()
[b2:b9].Formula = "=IF(M2<N2,TRUE, FALSE)"
End Sub

 

[Peter_SSs]

You do not need the IF() function in the formula

Sub test_v2()
  Range(Cells(2, 2), Cells(9, 2)).Formula = "=M2<N2"
End Sub

 

[montecarlo2012]

Thank you Mohadin and thank you Peter, great lesson for me. happy holyday.

 

[mohadin]

You are very welcome
And Thank you for the feedback
Be happy & safe