Paste after last row of data from one sheet to another

[Tapyr]

Hi friends,

I am trying to write down macro code which should make following.

1. In sheet called "Pivot" data from columns Q1:S copy until the last row
2. Copied data paste into Sheet "DFI" and paste it into column A, but at the end (there can exists some prior data which couldn't be replaced).

I got something ,but it doesn't work due Run-time error, Object doesn't support....

Could you pls help me fix it?

Please Login or Register  to view this content.

[skywriter]

You have lastrow2 declared as a string, it should be a number.

[Tapyr]

If I changed it as follows, it doesn't work and Compile error occured

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

[Tapyr]

Thank you AB33, it works.