Is this what you are looking for: Rows(rowToCopy).Copy
Destination:=Rows(Range("a65536").End(xlUp).Row + 1)

What you at least do wrong is enter a .copy statement an then say
Application.CutCopyMode = False
With the last statement, you eliminate the previous .copy
statement(s).


strataguru wrote in message ...
thanks for the response.

i am copying a row for the same worksheet that i want to paste onto.

let's say i have rows 1 through 15 filled with data (test case data in
this case) - and my program determines row 5 needs to be copied
(basically - i wanna replicate the data on row 5) and put it in row 16
- because it's the first available row without any information in it.

so - i wanna copy row 5 and paste the values into row 16.

hope that helps. i tried your code - but i need to reference rows
implicitly.

thanks!


---
Message posted from http://www.ExcelForum.com/