Find Duplicate Cells in Excel Data

Category:
Office/VBA
Type:
Snippets
Difficulty:
Intermediate
Author:
Anonymous

Version 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:

Code: