Hi everybody

I use:

rng.EntireRow.copy Destination:_
CurrentWkbk.Worksheets("sheet1").cells(Rows.Count, 1).End(xlUp)(2)

to copy entire row.

How can I copy just form column A to N.

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