I have a column that has duplicate values that I would like to remove. If I reference the column (Column N in this case) I can get this to work with the following syntax.
Private Sub CommandButton1_Click()
Dim firstvalue As String
Dim lastvalue As String
Dim arraystr() As String...