Pasting into a new line

[Tibbs]

Quite a while ago, the good people of these forums helped me out with a vba problem. The code I derived out of it is pasted below, but I appear to have screwed it up, as it doesn't select the next available row, it just pastes it over the top of the existing data.

Can anybody help me and tell me what I've done wrong?

Many thanks in advance,

Chris

Please Login or Register  to view this content.

Chris Please ensure you read private message re - VBA code wrapping

[mudraker]

This line of code does not find the next vacant cell - it finds the last used cell in column A

Please Login or Register  to view this content.

You need to add 1 to it

Please Login or Register  to view this content.

[antoka05]

I'm not sure but may be column 'A' (where macro get the first free row) has no data while other columns have data in the row when there are no data in column 'A'.

If the problem is this you can try to replace the code:

Please Login or Register  to view this content.

with this:

Please Login or Register  to view this content.

I hope it can help you.

Regards,
Antonio

[Tibbs]

Dear both,

Thank you so much for helping me - I've managed to solve the problem!

I picked a column that I know will always have data in it. That fixed the problem.

Thanks again,

Chris

P.S. Mudraker - PM read digested and understood - won't happen again