using the down end

  • Thread starter Thread starter Ed Davis
  • Start date Start date
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
 
dlr=sheets("sheet2").cells(rows.count,"a").end(xlup).row+1
sheets("sheet1").range("something").copy sheets("sheet2").cells(dlr,1)
 
Back
Top