Create a Unique List from Column A (Excel Macro)
Category:
Office/VBAType:
SnippetsDifficulty:
IntermediateAuthor:
Dave HawleyVersion 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: