Access to Excel - inserting rows (1 Viewer)

Hello everyone,

I'm trying to add two rows to the top of an Excel worksheet "qryCFP" from a workbook using the following vba code from Access:


I get the error message "subscript out of range."

I realize that the code above will only add one row, but I was going to include it twice in the subroutine. Is there anyone that can help with this error? It seems like it shouldn't be that difficult to accomplish, but I'm new to using Excel through access.

Thank you!

LMGTFY

First hit:
http://www.mrexcel.com/forum/micros...l-basic-applications-edit-excel-document.html

Should get you started.