Range.ColumnDifferences (Excel)

Returns a Range object that represents all the cells whose contents are different from the comparison cell in each column.

ColumnDifferences (Comparison)

Comparison: A single cell to compare to the specified range.

Dim rngColumnDifferences As Range
Set rngColumnDifferences = ActiveCell.ColumnDifferences(Comparison:=)