Dear Everyone,
I am wondering if you can write me a VBA code for comparing the value inside a cell.
Thank you for your support,
I am wondering if you can write me a VBA code for comparing the value inside a cell.
Code:
For i = 1 To 159
If Sheets("sheet1").Cells(i, 1).Value = Sheets("sheet2").Cells(i, 1) then
..............
Else
Sheets("sheet1").Cells(i, 1).Value = 0
End If
Next i
End
Thank you for your support,