Fill Dynamic Range From Dynamic Source Range

Hi all,

Using Excel 2007.

I am trying to fill a dyanmic range from a dynamic source range
The columns for now are $F:$J but the source row and the size of the destination range will change with ever iteration.

I have it working except for the fill

Run-tim error '1004':
Autofill method of Range class failed

Here:

Please Login or Register  to view this content.

In my first pass, data is copied from a Retrieve sheet and copied to an Archive sheet beginning at Row 9.
Sheet, Application, Database, Date and Time values are added in Col's $F:$J at Row 9. So far so good.

Now I am trying to fill down $F$9:$J$9 down to $10:$14 but I keep receiving the error above.

Any thoughts?
thx
w

Full code

Please Login or Register  to view this content.

Post a Sample WORKBOOK.
Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Hi Dave,

I attached a sample of the file

thx
w