Question about range in VBA

Hi,

Please Login or Register  to view this content.

I would like to paste some data in two sheets. There are totally 6 files data. I try to use range, offset and end function to find the last cell of the column, to prevent replace the data pasted before. But the code shows defined error.

I am not familiar with VBA, so, I dont know how to make my idea into real. What should I change to make this code work??

Thank you!

What you need to do is pick a start point, go down to the end, the offset by a row

Please Login or Register  to view this content.

Originally Posted by Norie

Since a and b are ranges already you don't need Range().

So the code would look like this.

Please Login or Register  to view this content.

By the way, finding the next empty row should be a little easier with something like this.

Please Login or Register  to view this content.

Thanks for your reply!
The suggestion shows application-defined or object-defined error. Am I missing something important???

Originally Posted by Norie

How many arrays are contained in the array Arr?

Can you post the rest of the code?

Please Login or Register  to view this content.

There are totally 6 files, so, there should be 6 arrays.