For every row, find the first blank cell and "paste" values from another sheet

[fsalina]

People, I'm relative new to Excel VBA and I'm having a little bit trouble with the subject.

I have 2 sheets and want to, when I click a button, copy some information from one sheet and paste on the other one.

I don't know what i did wrong, since the program gives no error.

The code I've written:

Please Login or Register  to view this content.

[Olly]

Can you attach your workbook please.

[patel45]

can you attach a sample file for testing ?

[fsalina]

Here's my workbook.

[Olly]

Okay - assuming what you are trying to do is find the next blank row in sheet "Banco de Dados" and paste in values from sheet "Controle", then use:

Please Login or Register  to view this content.

[fsalina]

Thanks, dude! It worked great but now I have one question:

I'm trying to understand what this "End(xlUp)" means. I saw it in a line somewhere and thought it can fit someway my code but I don't know the mean of it and how to implement it in another code.

If you can explain it to me I'll be very glad!

Anyway, thank you very much.

[Olly]

It's the equivalent of pressing Ctrl-Up. So the bit of code that says;

Please Login or Register  to view this content.

is the equivalent of going to the last row of column A, then pressing Ctrl-Up to move to the last cell with something in it.

It's the quickest way of find the end of a used range, and working from the bottom up is more reliable than working from the top down, as that method will only find the last cell before an empty cell, which may not be the last actual used row of the column.

Hope that clarifies!

[fsalina]

Now I understand.
Thanks a lot, man.