View Single Post
 
Old 11-28-2017, 10:00 PM
Ardcore1984 Ardcore1984 is offline Windows 10 Office 2016
Novice
 
Join Date: Nov 2017
Posts: 2
Ardcore1984 is on a distinguished road
Default Marco to find and delete unwanted blank rows in manuscript

Hi all,

I have some experience with VBA in Excel but this is my first attempt at a VBA solution in Word. I'm writing a novel in Scrivener and I periodically export it to Word for various reasons. When I export to Word, Scrivener adds an extra unwanted row between scenes. I use ### to indicate the end of a scene. I'd like to have a macro that cycles through my manuscript looking for all instances of "###" and then deletes the empty row that immediately follows it. I'm attaching a screenshot to help explain.

Any takers for this? It would be much appreciated as I do this export fairly frequently and there are enough scenes in the book that make it not feasible to do this manually.

Attached Images
File Type: png scene break.PNG (38.6 KB, 13 views)
Reply With Quote