• Home
 · 
• Encryption
 · 
• This is find out the duplicate entry's in excel.

This is find out the duplicate entry's in excel.

This is find out the duplicate entry's in excel.

Rate This is find out the duplicate entry's in excel.

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

Dim Var1 As Range
Set Var1 = ThisWorkbook.Worksheets("InfoSheet").Range("e3")
Set foundCell = ThisWorkbook.Worksheets("Pending").Columns("A").Find(Var1)
If foundCell Is Nothing Then
    MoveToLog     ‘Next Record or move to next subroutine
Else
    MsgBox "This appears to be a duplicate request. Please review pending list for possible duplicate entry in cell " & foundCell.Address
End If
End Sub