Do not add two spaces after Mr. or Ms.

macropod · #1 02-15-2017, 04:48 AM

Quote:

Originally Posted by slaycock

Try the following as a more sophisticated approach.

More sophisticated, maybe, but:
1. It lack the code to call it - it can't run on its own; and
2. Your loop with its repeated selections (myRange.Select) is very inefficient - you should be able to do the lot without selecting anything (except for whatever is selected when the calling macro is run). There are plenty of examples of such code on this forum.

slaycock · #2 02-15-2017, 05:28 AM

Quote:

More sophisticated, maybe, but:
1. It lack the code to call it - it can't run on its own; and

Mea culpa. If the OP can't work out how to use the macro it is easy to post en example of how to do so.

Quote:

2. Your loop with its repeated selections (myRange.Select) is very inefficient - you should be able to do the lot without selecting anything (except for whatever is selected when the calling macro is run). There are plenty of examples of such code on this forum.

Agreed. I've learned a heck of a lot by looking at your code examples. Hence

Quote:

' The myrange.Select are included to show the logic when stepping
' Through the code with F8. They should be deleted for general use

Which admittedly occurs halfway through the macro so might easily be overlooked.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Two spaces after a period	mysterytramp	Word	14	11-06-2017 02:01 PM
Spaces in a chart	AIKA	Excel	3	10-27-2015 01:37 AM
Spaces between words, help!	cheffie	Word	2	10-02-2013 01:59 PM
Strange spaces	Trevor_Bauer	Word	1	03-08-2012 11:56 AM
Spaces After Each Word	jnutella	Word	0	03-04-2009 02:00 PM