With this loop, somehow and SOMETIMES the cells.find statement (the one that is finding the Title of the next section) is making the macro enter debugging mode when the whole macro is run at once. Other times it works perfectly. The cell it's trying to find is always there (the title's name / cell.value never changes), so I'm not sure where exactly the error is coming from, especially since it's not happening all the time.
Bookmarks