Hi Tom.
Your code was perfect, the sytax error appears because o
the last line you mentioned 'sheet2' instead of "sheet2" corrected i
and it works . thanks for the help. Now i am trying for little twis
that the destination row is a permanent place ie sheet 2 row(1). I
possible when you get time please consider that. Any how once agai
thanks a lot
with
regards
nowfa

--
nowfa
-----------------------------------------------------------------------
nowfal's Profile: http://www.excelforum.com/member.php...fo&userid=1000
View this thread: http://www.excelforum.com/showthread.php?threadid=38621