Finding the blank row between 2 data blocks...should be simple...

Bit embarrased to ask this here but somehow I have trouble pinpointing the first blank/empty row between to large data blocks.

Like this code gives me the really lastrow on the sheet

Please Login or Register  to view this content.

but I also would need to know the first blank row between block of data 1 and the last row returned by above code in order to copy both blocks separately.

I cannot seem to find a working piece of code online somehow.
Code with find or match and then " " just won't cut it.
Anybody the simple answer here?

Thanks Robert!
I knew it could not be difficult but was messing up the code myself.
Also the starting point (like you mentioned) was somewhat important for this.

Maybe:

Please Login or Register  to view this content.

Hi adyteo and John,
Thanks for your answer they would work to.

Maybe this too..

It will give you the row number between each block of data regardless of how many blocks you have..

Please Login or Register  to view this content.

Thanks apo looks also like very interesting code.

Hi Robert,
Yes great options.
And infact I already marked as solved after the first solution of you so the thread seems pretty marked solved to me