Create a Unique List from Column A (Excel Macro)

Category:
Office/VBA
Type:
Snippets
Difficulty:
Intermediate
Author:
Dave Hawley

Version Compatibility: Visual Basic 6

More information:
This will take all the unique values out of Excel column A and populate a different column, starting at the destination cell you specify in an input box.

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:

Code: