Thank you for your replies JapanDave. Unfortunetly it still gets stuck at that same line. I've attached your macro file below and I've put a very long response into the rational column. If you run the macro you will see that it stops at the line.Excel Problem.xlsm