Change first row of last column

[ls8]

I started by using this code to copy a group of columns from one workbook to another. The columns should come from D-K on the source workbook and be inserted into the first empty columns in the target workbook.

Please Login or Register  to view this content.

The above code worked correctly, but I wanted all of the columns I copied to be shifted down 1 row, so I modified the code to be this, which is probably a little awkward, but it works.

Please Login or Register  to view this content.

Now, all of those new columns I created have the first row empty, and I am trying to figure out how to put data into those specific cells. My goal is for the first row of these newly created columns to contain the date, as obtained from the filename of the source workbook. For now, I am trying to insert any data into these cells, but I cannot figure how to specify which cells I want.

Any advice would be appreciated.

[Kelshaer]

use this code instead of all what you posted

Please Login or Register  to view this content.

[TMS]

Maybe just:

Please Login or Register  to view this content.

Or maybe:

Please Login or Register  to view this content.

Having established the next "free" column, you can use that as the starting point for inserting data:

Please Login or Register  to view this content.

Regards, TMS

[ls8]

I used your code Kelshaer:

Please Login or Register  to view this content.

This did exactly what I wanted. Thanks for your help.