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.