using the down end

E

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
 
D

Don Guillett

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