Remove duplicates from multiple columns using VBA

Hi,

Is there a VBA code I can use to remove duplicates from multiples columns to get a single unique list?

I have a matrix with about 300 rows and 30 columns which only have about 15 unique names in the 9000 odd cells. Is there a way I can get a unique list of the names in my matrix?

Thanks!

If it's a one time off thing, I would manually combine all the columns into 1 column and then use Excel's remove duplicates function.