Hi everybody

I need A macro which can be :


1- find a range (if there is any) in sheet1 in source workbook.
2- Copy row to to first row in Destworkbook.sheet1
3- repeat to every sheets in sourcebook and copy row to next row i
Destworkbook.

Regards
HM

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