Autofill error???

[luvbite38]

Hi guys,

I am trying to autofill using the following code but no luck, can someone kindly help me correct the following code,

Range("B4:T4").AutoFill Destination:=Range("B4:T" & Range("T" & Rows.Count).End(xlUp).Row)

All I want to select the range A4:T4 and autofill down.

Thanks in advance

 

[Andrew Poulsom]

What's below T4?

 

[luvbite38]

In column A I have values and below B4:T4 blank cells.

I somehow want macro to autofill the B4:T4 to autofill to the same no. of rows as vals in Column A

and if there is only one value in Col A i.e. A4 don't autofill..

Thanks Andrew

 

[Andrew Poulsom]

That's:

Range("B4:T4").AutoFill Destination:=Range("B4:T" & Range("A" & Rows.Count).End(xlUp).Row)

 

[luvbite38]

Thanks Andrew,

you're super awesome :D