So I have to write a macro which automatically finds and extends a range which I have set to this 
      Range(startcell, endcell).Select
into the next empty column, but for some reason when I try to do that with this line;
Selection.AutoFill Destination:=Range(startcell, endcell),lcol) Type:=xlFillDefault
i get a 1004 error. Any ideas? lcol is what I have set as the next empty column.