Finding the first empty cell

[Luiz]

My problem is that I have to copy and paste some datas under anothers but I don't know the code to do so; I mean, the code to paste on the first empty cell under the previously used cell.

Please Login or Register  to view this content.

When I do that the next paste (the datas from "E5:G5") will be from the last line of the last list pasted above (the datas from "A5:C5"). This way I always loose the last data of the previoulsy list.

Thanks for the help,

Luiz

[JBeaucaire]

How about this:

Please Login or Register  to view this content.

[Luiz]

JBeaucaire,

thanks, but it didn't work......

the thing is that I need to copy an entire set of data of the columns A to C and paste it on the BF column. Than, copy data from the columns E to G and paste them on BF column under the data from A to C.
The macro I've posted does it, but the last line of the A to C data is always lost, because the data of E to G columns are pasted over it.

[JBeaucaire]

The two lines of code I provided do exactly that. Here's another:

Please Login or Register  to view this content.

[Luiz]

Thanks JBeaucaire
problem solved!

[Luiz]

Thanks for helping JBeaucaire, but I didn't make it for the 14 times that I need......... it does not even finish.... stops during the process.......

Please Login or Register  to view this content.

Here it is the Macro I've built from the one you suggest tha works when it's just the first 2 lines, but when I replicate it to all of them it stops on the third line(the range "I5:K5").

what should I change so this works?

Thanks

[JBeaucaire]

It's xlDown as in "excel-down" ...you put in a 1 (x1Down) instead on a lowercase "l", not the same thing.

Put Option Explicit at the top of the module and it will point out typos like this for you.

[shg]

If you put Option Explicit at the top of every module, you wouldn't have those kinds of problems.

[Luiz]

is this correct?

Please Login or Register  to view this content.

Cause it didn't worked..... keep stoping in the third line not even finishing the macro........
about the module you've said I didn't unterstand it..... where i can see it? to the down left?

[Luiz]

aaaaa.............. thanks guys
It worked perfectly!!! Thanks very much.

but the Module thing, I didn't find it...........

[shg]

You code is in a code module.

As the very first line, before any procedures or anything else, put this line:

Please Login or Register  to view this content.

[Luiz]

Would look like this?

Please Login or Register  to view this content.

[shg]

No; it goes above EVERYTHING, and it's not a comment.