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