Pasting into a Range instead of last used row

[ScabbyDog]

So the below code I have succesfully pastes copied data into the last used row of column A. However at times there may be data in cells A32 and below which I want to exclude for the purpose of pasting. So how can I alter the code so that it only pastes in the last used row within the range A2:A31?

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Faridwahidi]

hi ScabbyDog,

You may try this,

Please Login or Register  to view this content.