excel formula compare cells in different rows code example

Example: excel vba How to compare two entire rows in a sheet

MsgBox [and(1:1=2:2)]