compare each cell of column to same cell of another column code example

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

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