Hi,

I have a workbook which is running code and it creates a number of new workbooks. Upon creating a workbook, the code will copy some values to the new workbook onto sheet1 I then want to fill some columns with the value located in row 2 of each column. However, I'm getting the 1004 error when the line below is executed;

Code:
        ActiveWorkbook.ActiveSheet.Range(Cells(2, 1), Cells(22, 1)).FillDown
Any idea how I can get teh line to work?

THanks.