When I want to address a range of cells I have been using a formula such as
the following:
Selection.AutoFill Destination:=Range.Cells("W2:W6475"), Type:=xlFillDefault
This works quite well when the length is fixed or doesn't change very much,
but I have a situation where the range varies dramatically and my thought
was to use the following :
Selection.AutoFill Destination:=Range.Cells(2,26:Limit,26),
Type:=xlFillDefault
where "limit" was the last row count and it, of course, failed.

Is there a simple way of doing this?

Thanks,
Craig