This is one of the strange VB problems you may face using even very simple macros.

Your macro runs fine, but in the end (end sub) you receive a code execution error, that the macro is interrupted and you need to debug, etc.

Here is a way to avoid this absurd problem.

In the beginning of your macro, before all other code lines, add this one:

Application.EnableCancelKey = xlDisabled

Enjoy!

Being yourself an author or student you will perhaps appreciate especially this feature, that the very structure of the book will teach you how to work. The book contains even chapters on how to prepare a document for professional publishers such as Amazon. Reading Steven Adams' Writing a book or thesis in Microsoft Word you are surprised realizing it makes you want to work -- to think, write, use Word and be creative!