Prev: Run-time error '380'
Next: Error on Code
From: LaDdIe on 16 Feb 2010 14:41
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
>
>
From: LaDdIe on 16 Feb 2010 14:45
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
> >
> >
First  |  Prev  | 
Pages: 1 2
Prev: Run-time error '380'
Next: Error on Code