Question: how to find unique values vba?
Answer: Activate the Visual Basic Editor by pressing ALT+F11 . Right-click the project/workbook name in the Project window. Choose Insert -> Module . Type or paste the code in the newly created module. Close the VBE widow. Select the range which you want to remove duplicate values.