Hang on wait a minute,

Thank you Ossiemac, eveything is tickty boo.

Cheers

"LaDdIe" wrote:

Once again thank you for your assitance,

I have tried all combinations of code and keeping getting this error:
Run-time error 1004
Method 'range' of object'_Global failed.

Would you be able to shed some light.

"OssieMac" wrote:

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