Copying and pasting arrays of data to the last row of an existing array which contains blank cells

[macca_18380]

Hi,

I want to copy and paste several arrays of the same size from different tabs into a single tab pasting each new array underneath the last. The arrays i'm copying contains blank cells so i need to try and find the final row with data in it before pasting my next array.

Any help and tips are much appreciated, thank you.

Michael

 

[Kaper]

You've published this question in a general forum "Excel Questions".
What method do you use now to find final for and what method do you use for copying/pasting.
If you use VBA (I suspect it is the case) you may consider:

   lastRow = ActiveSheet.Cells.Find("*", searchorder:=xlByRows, searchdirection:=xlPrevious).Row