Copy values of range immediately below same range excel vba

[drluke]

In my worksheet I have continuous rows with data in D7:D726. I column E I have data from E7:E24. I need to copy the data
in range E7:E24 and autofill the remaining rows in col E (i.e. E25:E726) with that range of values.

The ranges in both col D and the initial range to be copied in col E will never be the same.

So far I have tried this code:

Range("E7:E" & Range("D" & Rows.Count).End(xlUp).Row).Value = Range("E7:E" & Range("E" & Rows.Count) _
.End(xlUp).Row).Value

The result I'm getting (in E25:E726) is #N/A
Any advise much appreciated.

 

[DanteAmor]

Re: Autofill syntax error

I'm getting a syntax error on this line of code:

Range("E7:E" & Range("E" & Rows.Count).End(xlUp).Row).AutoFill Destination:=Range("E7:E" & Range("D" & Rows.Count).End(xlUp).Row), xlFillValues

I can't work out what is wrong. Any advice appreciated.

My code in #5

    Range("E7:E" & Range("E" & Rows.Count).End(xlUp).Row).AutoFill _
         [COLOR=#0000ff]Destination[/COLOR]:=Range("E7:E" & Range("D" & Rows.Count).End(xlUp).Row), [COLOR=#0000ff]Type[/COLOR]:=xlFillValues

If you are going to put the argument name "Destination", then you must also put the argument name "Type"

Or omit the 2, as in the Fluff code:

    Range("E7:E" & Range("E" & Rows.Count).End(xlUp).Row).AutoFill _
            Range("E7:E" & Range("D" & Rows.Count).End(xlUp).Row), xlFillCopy

 

[Fluff]

Re: Autofill syntax error

Good spot Dante, I totally missed that.

 

[drluke]

Re: Autofill syntax error

Thank you all - awesome as always!

 

[DanteAmor]

Re: Autofill syntax error

Your welcome.