Hi,

I have a worksheet which changes the number of rows each day

 ActiveCell.AutoFill Destination:=Range("E3:E" & Range("D" & Rows.Count).End(xlUp).Row)
I have the above but i dont want to referance E3 as this cell may move up or down depending on the volume of data i have.

I basically want to use the ActiveCell and to auto populate based against column D.

Kind Regards

Chris