View Single Post
 
Old 03-24-2023, 12:43 PM
Charles Kenyon Charles Kenyon is offline Windows 11 Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,464
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by Bunnelope View Post
***
My macro request is much simpler than that. I don't want it to make any grammar suggestions at all. I just want it to identify long stretches without commas or periods by highlighting them. The macro that I found can do the same thing, but only accounts for long sentences. I assume that is because it counts the number of words between periods. I want one that will count the number of words between either commas or periods.

My use for this is in prepping manuscripts for narration. If I can identify a long, run-on sentence ahead of time, I can look at it and figure out ahead of time where to breathe. I can then add a comma or another indicator manually to tell myself to breathe when I am recording the narration.
If I am now reading you correctly, what you want is a macro that checks text and if there is a sentence that is longer than 30 words, you want to check for the presence of a comma and then check to see

  1. if there is a portion of that sentence between the start of the sentence and the first comma,
  2. or between that comma and the next,
  3. or between the last comma and the period, is more than ? how many? words, you want that sentence marked so you can review it.
This, vba can do, but you need to determine how many words are allowed in a phrase before a breath. What is too long for a sentence? For a phrase?
Reply With Quote