Another option instead of using the colon and concatenating the range, a
comma can be used between the start and end ranges. (Similar to the Selection
example.)

Range("A4").AutoFill _
Destination:=Range("A4", _
Range("NETDAYS").Value)

--
Regards,

OssieMac