Thread: [Solved] VBA, Place Sentence in its own Line
View Single Post
 
Old 04-27-2017, 08:28 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
You don't really need any VBA for what you're doing - simply do a wildcard Find, where:
Find = [.\?\!^l^13]*[.\?\!^l^13]
As per VBA, of course, this will identify anything with a period in it as the end of a sentence but, other than that, each time you press 'Find Next' in the F/R dialogue, it will select the next 'sentence'. Since you're wanting to stop to add formatting, there's probably not much benefit in having a macro.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote