In an adjacent column add the formula

=IF(COUNTIF($A$1:A1,A1)1,"Dup","")

then filter by that mew column on Dup and delete all visible rows.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mariomaf" wrote in
message ...

There must be a simple method in VB to delete duplicate values. I tried
the advancedfilter, but I couldn't get it working.

Anyone able to help me out here...


--
mariomaf
------------------------------------------------------------------------
mariomaf's Profile:
http://www.excelforum.com/member.php...o&userid=30098
View this thread: http://www.excelforum.com/showthread...hreadid=498266