How about a simpler approach

Range.Cells("W2:W6475")
Range.Cells("W2:W" & limit)
How are you defining "limit"?
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"C Brandt" wrote in message
...
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