using the down end

[Ed Davis]

I am trying to use the down_end statement in a macro and it always lands on
the same spot.
I want to copy something from sheet_1 to the first open cell in sheet_2.
This position will change each time I copy data to it.
Can someone help me.
Thank you.
Ed Davis

 

[Don Guillett]

dlr=sheets("sheet2").cells(rows.count,"a").end(xlup).row+1
sheets("sheet1").range("something").copy sheets("sheet2").cells(dlr,1)