copy part of row
 

tank you tom
you are my savior

there is a additional "Entirerow " in the line 2 of your suggestion an
when it is removed it works excellent.

yours
HM

--
hm
-----------------------------------------------------------------------
hme's Profile: http://www.excelforum.com/member.php...fo&userid=1593
View this thread: http://www.excelforum.com/showthread.php?threadid=27796