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.

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



wrot
e in message ps.com...
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.