compare rows of 2 columns in excel code example

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

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