Hard to be sure without seeing the code, but I suspect you are pasting into a
cell that is not in column A. If you are doing this it will fail since the
"entire row" contains cells (blank ones count!) that would have to be pasted
beyond the upper limit of the worksheet columns. This happens if you do it
manually, too (select a row, copy, and paste into a cell in B and you will
see).

If this is indeed the reason it fails, paste into the destination cell's
..EntireRow and it should work.

"Raman325" wrote:


Why is the following not valid?


Code:
--------------------
Selection.EntireRow.Paste
--------------------


To understand the code in context, I have just copied a row using the
EntireRow property and I am now pasting it into another row, except it
is not working. Anyone have any suggestions?


--
Raman325
------------------------------------------------------------------------
Raman325's Profile: http://www.excelforum.com/member.php...o&userid=24748
View this thread: http://www.excelforum.com/showthread...hreadid=383224