excel vba compare 2 rows code example

Example 1: excel vba compare 2 rows

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

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

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

Tags:

Misc Example

Related