Answered by : vastemonde

With Application MsgBox Join(.Transpose(.Transpose(ActiveSheet.Rows(1).Value)), Chr(0)) = _ Join(.Transpose(.Transpose(ActiveSheet.Rows(2).Value)), Chr(0))
End With

Source : https://stackoverflow.com/questions/19395633/how-to-compare-two-entire-rows-in-a-sheet | Last Update : Wed, 17 Feb 21

Answered by : daniel-ferry

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

Source : https://stackoverflow.com/a/29960817/3566998 | Last Update : Wed, 01 Apr 20