Need to Change ActiveCell

[paulhunt08]

I am trying to copy and paste from one worksheet to another however, I
am trying to paste all the data to the new worksheet in Column A and
last occupied row.

I can copy all the data that I need fine and I can find the last
occupied row of the destination worksheet but the problem comes with
the pasting.

If I simply do a ".Paste" it will paste the data in the last cell that
I actually clicked on with my mouse (B7, D14, ....) It doesnt matter.
What I need help in determining is how to change the active cell to the
last occupied row of column A of the destination worksheet regardless
of where the last active cell actually is.

 

[N10]

HI

Do this before you paste. It probabley can be done without selecting but
here you go anyway


your copy code goes here

Range("A1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select

Best N10