View Single Post
 
Old 09-16-2013, 04:54 AM
sleake sleake is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Jul 2011
Posts: 60
sleake is on a distinguished road
Default Error in Macro to Add 2 Spaces After Closing Parenthesis

I've tried it with and without Wildcards. Present test version is without. I made the change you suggested -- .) -- because it would (should) always have a period. Good point about two spaces.

Unfortunately, I get the same error. I think we editors will need to do this manually doing a Find/Find Next (in case of two spaces) -- it works using the Replace command -- just not when it's in macro form.

I do have a macro (being "retired") to search for more than one space and replace with one after periods and colons. So I can keep that one for occasional use. Now I have a new one to search for 3 or more spaces and replace with 2 after periods and colons. We'll just have to do the .) manually.

Appreciate your response.
Reply With Quote