Hi,

In row5 I have a number of values, from 1 to 14. The values are sorte
ascending. When there are five values 1, the macro should select al
these cells with duplicate values and merge them.
The problem is I don't know how to do this.
Can someone help me with this problem? Thanks in advance

--
leonida
-----------------------------------------------------------------------
leonidas's Profile: http://www.excelforum.com/member.php...fo&userid=3537
View this thread: http://www.excelforum.com/showthread.php?threadid=57415