Possible simple question about: If then else sequence.

Dear Excel specialist(s),

I have a short question...
The script below reads all workbooks in a worksheet (until the last filled row) and copies them in a Planning_Summary overview workbook.
This works fine...

But, I would like to copy and paste all rows until the text "End" is found in the first column (case insensitive) and then move on to the next workbook.
Does anyone know, where to put that line of code (as easy as possible)? I don't know how to stop at this point (based on criteria).

Thank you in advance!

Please Login or Register  to view this content.

Hi GWteB,

This was exactly what I was looking for. Thank you very much for you quick support (over the moon).
Closing my request (as solved) and adding reputation

Best regards,

Hans