excel compare 2 cells and return value code example

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

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