Skip to content

Instantly share code, notes, and snippets.

@phuclv90
phuclv90 / VBA.vb
Created June 7, 2019 06:53
Highlight differences between strings in Excel
Sub highlight()
' https://www.extendoffice.com/documents/excel/3716-excel-compare-two-strings-highlight-differences-for-similarity.html
Dim xRg1 As Range
Dim xRg2 As Range
Dim xTxt As String
Dim xCell1 As Range
Dim xCell2 As Range
Dim I As Long
Dim J As Integer
Dim xLen As Integer