Dear Sujata

Why 9 ? I don't know where is lokated my range.

The Macro FIND a given range in all sheets af a workbook and copy th
entire row, where there is the range, to another workbook but I need t
copy only part of this row for example from A to N.

tanks a lot

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=27796