I tried it, but there is one problem with it.

I must it run more than once if I want to eliminate all empty cell
between values in my column.

tomm

--
tommy_gt
-----------------------------------------------------------------------
tommy_gtr's Profile: http://www.excelforum.com/member.php...fo&userid=2608
View this thread: http://www.excelforum.com/showthread.php?threadid=47410