Tom Ogilvy wrote:
With Range("startingcolumn")
.AutoFill Destination:= _
.Resize( ,Range("projectionyears").Value), _
Type:=xlFillDefault
End With

Thanks Tom, that's a very elegant solution.

Travis