[RESOLVED] Error 1004 (application or object error) : filldown command

[scoobster]

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;

        ActiveWorkbook.ActiveSheet.Range(Cells(2, 1), Cells(22, 1)).FillDown

Any idea how I can get teh line to work?

THanks.

[scoobster]

Fixed it.

I guess it's not possible to use (cells(x,y), cells(a, b) within a range or with the filldown. I just replaced the 2nd CELLS with a resize and the code runs through perfectly.