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/