variable row...
 

Copy down list to variable row?
Range("A3").Select
Selection.End(xlDown).Select
Row = ActiveCell.Row

Range("m4:w4").Select
Selection.AutoFill Destination:=Range("m4:E" & Row)
Range("m4:E" & Row).Select

should be simple :)

variable row...
 

If you are cxopying columns M:W, then the destination should be M:W, not
M:E.

Also using Row as a variable name is not a good idea, it is a VBA property.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"John" wrote in message
...
Copy down list to variable row?
Range("A3").Select
Selection.End(xlDown).Select
Row = ActiveCell.Row

Range("m4:w4").Select
Selection.AutoFill Destination:=Range("m4:E" & Row)
Range("m4:E" & Row).Select

should be simple :)