VBA code in Excel 2010 with Windows 7.

[hchisholm]

Hello all, I'm looking for VBA code that will find duplicates between two columns, but the duplicated value could be in different rows. So I could have a value in column c row 5 and the same value in column b row 132. Any assistance would be greatly appreciated.

 

[alansidman]

Try this:

Option Explicit
Sub Findupe()


Dim i As Long
Dim j As Long
Dim lr As Long


lr = Range("A" & Rows.Count).End(xlUp).Row
    For i = 1 To lr
        For j = 1 To lr
        If Range("B" & j) = Range("A" & i) Then
        MsgBox ("Duplicate in " & Range("B" & j).Address)
        End If
        Next j
    Next i
    
End Sub