title: Array of unique values in a Column range
body: <p>Trying to figure out the code to make an array of all unique values in a column.</p>
  <p>So like say from C3:C30 I want an array named divisionNames of all unique values in that range. I intend to use the array later in the code. Trying to figure out a minimalist way of doing it so I don't add like 60 more lines of code to the macro.</p>
  <p>Would be very appreciative of any suggestions</p>
  <p>UPDATE:</p>
  <p>Gary's Student's response below did the trick for what I needed, but I very much appreciate the help everyone gave. Thank you. Also as a side note I am now realizing I should have added that I am using Office 365. To be honest I didn't realize it made that much of a difference, but I will remember that for future reference and again thank you for all of the help</p>
  <pre><code>Sub uniq()
      With Application.WorksheetFunction
          divisionNames = .Unique(Range(&quot;C3:C30&quot;))
      End With
  End Sub
  </code></pre>