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

by koteswara rao (1 Submission)
Category: Encryption
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Sun 7^th November 2004
Date Added: Mon 8^th February 2021
Rating: (1 Votes)

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



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     &#8216;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

Download this snippet Add to My Saved Code

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

No comments have been posted about This is find out the duplicate entry's in excel.. Why not be the first to post a comment about 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. Comments

Post your comment

Difficulty