Thread: [Solved] VBA Swap text around
View Single Post
 
Old 11-27-2024, 03:03 AM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,466
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

Do be aware that doing that risks starting some sentences with a lower-case p, which is why I suggested the upper-case approach. The original code in the macro simply preserved whatever case it found, which could have produced some odd results at the start of sentences too (e.g. part 3 of Schedule 4 provides ... ).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote