Open workbook, insert copied rows VBA code

Originally Posted by xladept

Yeah-but what's on the clipboard in the first place-you're only going to insert at row 4 but what you insert is what's on the clipboard!

Thank you so much. I'm pretty certain you are correct, there was nothing on the clipboard to paste to the new workbook once opened. I fixed it with by putting

 Selection.Copy

before

 Workbooks.Open Filename:="X:\OSC DETAIL\Invoices Sent to AP\Sent Invoice Summary - 2012.xlsx"

Works like a charm now. Thanks again