Find Duplicate Cells in Excel Data
Category:
Office/VBAType:
SnippetsDifficulty:
IntermediateAuthor:
AnonymousVersion Compatibility: Visual Basic 6, Visual Basic Script
More information:
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.
Declarations: