Paste Value After Data

[luke6843]

I am attempting to copy data from sheet A (macro_sort) and paste value in sheet B (book) at the end of the data in sheet B. I am constantly adding data to sheet B so I need it to paste the new data after the existing data. I have included a copy of the code I am using. Currently it is pasting the data but not by value and not after the existing data; it is wiping out much of the existing data.

Please Login or Register  to view this content.

My macro skills are very very basic so I would appreciate any help in the most simplest of terms.

Thank you
Luke

[shg]

Welcome to the forum.

Please take a few minutes to read the Forum Rules, and then edit your post to wrap your code with Code Tags.

[royUK]

Try this

Please Login or Register  to view this content.

[DonkeyOte]

Luke, on an aside and given you're beginning your VBA journey note that this:

Please Login or Register  to view this content.

is equivalent to coding

Please Login or Register  to view this content.

if you want "a" to be a Long also you must declare explicitly in VBA

Please Login or Register  to view this content.