aleksandra123
New Member
Hi Guys,
I stuck at one point. I have a sheet where I need to delete some rows. Please find enclosed the sample file. I've marked in yellow the lines to be deleted. What is important the "data"lines are changing sometimes is 5 sometimes is 10 thats way I am thinking to have DO until loop which will be searching first blank line then delete this line along with next 5 lines and then come back and search the new blank line and delete and so on. But I dont know how to finish the loop. Any ideas?
I stuck at one point. I have a sheet where I need to delete some rows. Please find enclosed the sample file. I've marked in yellow the lines to be deleted. What is important the "data"lines are changing sometimes is 5 sometimes is 10 thats way I am thinking to have DO until loop which will be searching first blank line then delete this line along with next 5 lines and then come back and search the new blank line and delete and so on. But I dont know how to finish the loop. Any ideas?