Hello,
I am kind of despairing with three nested Loops.
I am trying the following.
As soon as in cells (i,10) is the letter "X" a new loop should start until the letter "Y" is reached in the same column.
In the just opened loop another loop should search for triple XXXs (not the movie) ;-) and in case it found one another loop should fill the cells, starting one cell below the cell in which the XXX was found.
I have also attached my code and my sheet to solve this. Unfortunately I couldnt find the solution myself.
You can alsos ee in my sample what the macro (Macro) does and what it should do (Target)
I hope anybody can help me out here, highly appreciated.
Cheers
HTML Code:
Bookmarks