Removing duplicates from multiple columns (treating each column separately)

hi all

Hopefully the description is self explanatory

http://i.imgur.com/MkPEs1l.png

I know how to remove duplicates from a columns but i have 200+ columns and will need to perform this on all.

I couldnt find anything on the net. I found this http://www.mrexcel.com/forum/excel-q...e-columns.html but the vba came up with an error (not sure if its because I have excel 2003?)

Anyway, assistance would be greatly appreciated

thanks !!