title: VBA - How to remove empty cell from array
body: <p>I've got a range that I'm inserting into an array.
  after that, I'm trying to get only the unique Items but I get them with one (unique) empty value (There are few blanks in my range).</p>
  <p><strong>How can I get rid of the empty array cell?</strong></p>
  <p>This is my code:</p>
  <pre><code>Sub uniqueArray()
  
  Dim myList As Variant
  uniqueNameList As Variant
  
  myList = Range(&quot;C2:C100&quot;).Value
  uniqueNameList = WorksheetFunction.Unique(myList)
  
  End sub
  </code></pre>
  <p>for example:
  <a href="https://i.stack.imgur.com/VpDgY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VpDgY.png" alt="enter image description here" /></a></p>