Alex,

On sheet BD1, do you have any data in column C in/after row 6? If not, that
would cause the error.

Both of the suggestions worked for me, although I did have to put a line
continuation character (space underscore space) in this one after
PasteSpecial:

Sheets("NEW").Range("K12:O12").Copy
Sheets("BD1").Range("C5").End(xlDown).Offset(1, 0).PasteSpecial _
Paste:=xlPasteValues

Regards,

Patti



"Alex Martins" wrote in message
...
Hey K...I couldn't make that work...thanks for the help. If you think of
anything else please let me know.

Thanks again for your help!
Alex

"kraljb" wrote:


Sheets("NEW").Range("K12:O12").Copy
Sheets("BD1").Range("C5").End(xlDown).Offset(1, 0).PasteSpecial
Paste:=xlPasteValues

Hope that helps


--
kraljb
------------------------------------------------------------------------
kraljb's Profile:
http://www.excelforum.com/member.php...fo&userid=9955
View this thread:
http://www.excelforum.com/showthread...hreadid=400915