I have a range I am looping through in VBA:

```
For Lrow = Firstrow To Lastrow Step 1
        With .Cells(Lrow, "E")
            If Not IsError(.Value) Then

            End If
        End With
    Next Lrow

```

Within that if statement I need to load an array with each value only once

MB-NMB-ILA  

MB-NMB-ILA  

MB-NMB-STP  

MB-NMB-STP  

MB-NMB-WAS  

MB-NMB-WAS  

MB-NMB-WAS  

So for the array I only want MB-NMB-ILA, MB-NMB-STP, and MB-NMB-WAS

Can anyone help me out, my brain isn't working right on a Monday! Thanks