lks55
03-23-2016, 10:21 AM
hi
I have a document and sometimes there is a line empty. The loop should stop when 2 lines in a row are empty. I tried this:
Do While Cells(s2, 2) And Cells(s2 + 1, 2) <> "end"
But it tells me "Subscript out of range". I looked up some pages in google, but haven't found something helpful. Has anybody an idea for my problem or an other solution?
Best Regards
I have a document and sometimes there is a line empty. The loop should stop when 2 lines in a row are empty. I tried this:
Do While Cells(s2, 2) And Cells(s2 + 1, 2) <> "end"
But it tells me "Subscript out of range". I looked up some pages in google, but haven't found something helpful. Has anybody an idea for my problem or an other solution?
Best Regards