Count Unique Values in Column within VBA

[vansicklej]

Hi All,

I'd like to load a variable within VBA with the result of a Unique values count in a given column in Excel. For example:

Column 1
36"
42"
36"
48"
48"
42"

I've added a button which does some things, and part of what I want it to do on click, is to go down column 1 and:

Set mycount = CountUnique (myrange)

The mycount value would then become "3" in this instance.

Everything I've been able to find thus far requires a cell formula entry, however I'd like mine to be entirely in VBA code.

Hope this makes sense.

Thanks for any help you can offer.

- J

[JieJenn]

Try UDF as in the file attached.