Concatenate and Autofill

[djsmarties]

Hi all,

I am running into problems with the concatenate/ filling funtion in my macro.

I am combining two cells and then the formula should autofill until my last row. I am using this succesfully with other formulas, but concatenate does not seem to want to do it.
Getting error message: "Autofill method of range class failed"
Am I missing something really obvious?

Thanks a lot

****************

Range("AT2").Select
Selection.AutoFill Destination:=Range("AT2:AT" & Cells(Rows.Count, 1).End(xlUp).Row), Type:=xlFillDefault
Range("AT7").Select

**********************