Macro to get unique values from range of cells?

Hi guys, got a question relating to vba. I've done some coding so know roughly what I need to do, just don't have that much experience in excel/ vb.

So, what I want to do is get all the unique values from a range of cells and print them in another range of cells, one value per cell. For example, this would be the result:

Original List	Result of Macro
a	a
a	b
b	c
c
a

I assume this would be done by putting the values into an array and then printing that array with some kind of loop (but please correct me if I'm wrong, that guess is based off other code applicaitons).

If possible it'd be great if the macro ignored cells with commas in them e.g. if the contents of a cell was "a,b" it would just skip that cell.

Thanks for any help in advance, and sorry for the newbie question!

Maybe:

Please Login or Register  to view this content.

Results from Column A to Column B.

Another one.. much the same as JHD's..

Please Login or Register  to view this content.

Thanks guys, will try out now!