Column Differences is a method which determines differences against given match criteria range. This method take Comparison argument which should be a Range object, needs to be compared and returns a Range object.
Public Sub ColumnDifferenceExample() 'object to bind selection Dim oSourceRange As Range 'Bind selection to range object Set oSourceRange = Selection 'object to be matched Dim oRangeToMatch As Range 'Bind range Set oRangeToMatch = Range("A2") 'object to hold difference result Dim oUniqueRange As Range 'Perform difference Set oUniqueRange = oSourceRange.ColumnDifferences(oRangeToMatch) 'Select the range found different oUniqueRange.Select 'Format font color oUniqueRange.Font.Color = vbRed 'Fill cell beackground oUniqueRange.Interior.Color = vbBlue 'Memory cleanup Set oSourceRange = Nothing Set oRangeToMatch = Nothing Set oUniqueRange = Nothing End Sub
Above code will will match range A2 which has “VBAOVERALL” as cell content and does a comparison over Range A2:A7 and perform formatting like Cell background color change, font color change and select the same:
Please leave your comments or queries under comment section also please do subscribe to our blogs to keep your self upto date.