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:
' (None)

Code: