Just go through the steps with the macro recorder on

- insert column B
- add the formula
- add the autofilter
- filter the data
- delete the visible rows
- delete column B

It will need tweaking, but you have the basic macro then.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mariomaf" wrote in
message ...

The idea worked and is helpfull indeed. But isn't there an VB solution
which is better? Now I have a "Dup" value for each duplicate value and
I should delete these values in VB. So I would prefer to combine. So I
think I am gonna transform the worksheet code into VB code .

Once finished I will post it here for others to use.


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