I didn't understand properly what you asked - you asked me to "supply what I have"...
Actually I did NOT ask you that. I asked:
Can you post a sample document, removing any sensitive information?
Document. I do not think I could be more clear. Document.

As you did not, I could hardly see that you did not have what you said were paragraphs, nor empty paragraphs. That is why I wanted to see what you were actually working with. Heck you did not even say if the document I posted worked for you. You did not have even download it, just open the posted file and press Ctrl-d. You can see that it works doing what you asked for. BUT with full paragraphs.

I could have answered the 5941 error immediately. Please, in the future try to answer questions asked of you. I also asked
Are you saying my macro in MY file did not work on your machine?
and you have not answered either. And yes I am annoyed.