Hi softy.
Welcome to the forum and thanks for posting.
The synatx 
RemoveDuplicates Columns:=1, Header:=  xlYes
will only work in xl2007 and xl2010
in xl2003 you can use the auto filter