I have movie scripts. First column is time code, second column is speaker, third column is dialog.
I want to loop through the entire script, but only doing something to the third column (dialog).
I already have a macro for what I do to the third column. I just need it to:
- start in row 1 column 1
- tab to row 1 column 2
- tab again to row 1 column 3 (then do my pre-built macro)
- then tab again taking me back to r2 c1
But it has to stop when it hits an empty table cell. My macros keep hitting infinite loops, continuing to create new cells as the tab key is programmatically checked despite many different checks for end of document. All solutions out there assume it is an ordinary, non-tabled document, and code such as:
Do Until ActiveDocument.Bookmarks("\Sel") = ActiveDocument.Bookmarks("\EndOfDoc") '(Do something) Loop