title: Loading an array with only unique values
body: <p>I have a range I am looping through in VBA:</p>
  
  <pre><code>For Lrow = Firstrow To Lastrow Step 1
          With .Cells(Lrow, "E")
              If Not IsError(.Value) Then
  
              End If
          End With
      Next Lrow
  </code></pre>
  
  <p>Within that if statement I need to load an array with each value only once</p>
  
  <p>MB-NMB-ILA<br />
  MB-NMB-ILA<br />
  MB-NMB-STP<br />
  MB-NMB-STP<br />
  MB-NMB-WAS<br />
  MB-NMB-WAS<br />
  MB-NMB-WAS<br /></p>
  
  <p>So for the array I only want MB-NMB-ILA, MB-NMB-STP, and MB-NMB-WAS</p>
  
  <p>Can anyone help me out, my brain isn't working right on a Monday! Thanks</p>