According to your attachment for your Button 1 an Excel basics VBA demonstration
like any Excel beginner operating manually and using the Macro Recorder :

PHP Code: 
Sub Macro1()
    [
A1].CurrentRegion.RemoveDuplicates 21
End Sub 
► Do you like it ? ► So thanks to click on bottom left star icon ? Add Reputation ? !