I have a sub that does some formatting and then pastes a result at the first empty cell after the information that is there.

How can i do a look for this so it does this continuously until you get a Debug because there are no more results in the formatting.

I was looking at Loops but got lost in circles in them (haha)

Once the looks are compete i Just want to end the sub.

Thanks