I am using VBA in Excel to generate a weekly report in Microsoft Word.
There are extra line breaks after the first line of the document and the beginning of the next line that I would like to remove so there's only one blank line in between the first and second sentence of the document for example:
"Sat 28 Jun to Mon 6 Jul 2018
Second line begins here"
I would also like to remove any blank lines at the end of the document.
How can I achieve this using VBA in Excel?
There are extra line breaks after the first line of the document and the beginning of the next line that I would like to remove so there's only one blank line in between the first and second sentence of the document for example:
"Sat 28 Jun to Mon 6 Jul 2018
Second line begins here"
I would also like to remove any blank lines at the end of the document.
How can I achieve this using VBA in Excel?
