What is the number of rows that you need to copy. Also it could be
possible that you are going out of the sheet range and thats where it
is failing to paste. Maybe you could send me your worksheet and I'll
have a look at it. send it to
Don't forget to remove the text remove this from the email id.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=374455