As explained by Michael Alexander, author of several books on business analysis with Access and Excel, in Excel Trick’s Ankit Kaul mentions how blank rows can make your life painful if, for example, you’re planning to import an Excel worksheet into other applications, such as Access.
The main point is: you want to be able to delete blank rows or rows that have blank cells quickly and easily. There are several ways to create a macro that deletes blank rows or rows with blanks cells.
Many times the macro may do quite a bit with the document, such as jumping to different places, replacing text, and taking other types of actions.
This means that the Word screen can look like it has "gone crazy" while the macro is running.
I don't find Suspend Layout() and Resume Layout() does what you are asking for.
The Lock Windows Update() metioned by moobaa does the trick.
One thing you may want to do with your macro to make it run faster and to prevent distracting flashes on the screen is to turn off screen updating while the macro is running.
But it also works even if you run your Automation code from Word itself.
In fact, you can find many different suggestions online.
Instead of trying to re-invent the wheel, in this tutorial I show you 5 of the most common examples of macros to delete blank rows or rows with empty cells quickly and easily.
Word does not need to display itself in order to run.
In the above code, you could omit the lines that create and use the Word.