Find Duplicate Cells in Excel Data
Version Compatibility: Visual Basic 6, Visual Basic Script
The included function here let's find cells with duplicate data in Excel. The only caveat is that you must have a cell selected to start and the column must be sorted.
Instructions: Copy the declarations and code below and paste directly into your VB project.