Before your code will have a chance of running, you'll need to replace all those 'smart' single quotes and double quotes with straight quotes. Even then, however, you should be aware that VBA has no idea what a grammatical sentence is. For example, consider the following:
Quote:
Mr. Smith spent $1,234.56 at Dr. John's Grocery Store, to buy: 10.25kg of potatoes; 10kg of avocados; and 15.1kg of Mrs. Green's Mt. Pleasant macadamia nuts.
|
For you and me, that would count as one sentence; for VBA it counts as 5 sentences.