montecarlo2012
Well-known Member
- Joined
- Jan 26, 2011
- Messages
- 984
- Office Version
- 2010
- Platform
- Windows
Hello.
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.
VBA Code:
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
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.