vba, how to use vba to search how many distinct amount in same column?

[perhapscwk]

vba, how to use vba to search how many distinct amount in same column?

for example..
column C have amount

123
123
444
123
445
444

then after using vba, it will show you it is 4 unique element..

Thanks

[jamesd0142]

vba, how to use vba to search how many distinct amount in same column?

for example..
column C have amount

123
123
444
123
445
444

then after using vba, it will show you it is 4 unique element..

Thanks

if your querying from a database then the sql staement will be somthing like...

select distinct count(<columnname>) from <tablename>
 

if your not using a database, could you explain where these values are stored...

================================================== ===
By the way theres 3 unique rows in you example :P
================================================== ===
Thanks James

[perhapscwk]

it is from a excel file and i want to use vba to calculate it