Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-07-2014, 01:15 AM
macropod's Avatar
macropod macropod is offline Multiple replace does not work with 2013 Windows 7 32bit Multiple replace does not work with 2013 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,512
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

At least some of the issues you're having, especially with numbers, are because the code uses ".MatchWholeWord = True". Without this, there would be a significant risk that some of your other Find/Replace expressions would be updating parts of words. That may also explain why it doesn't work with "No-width optional break" text. I don't understand why you'd bother with rows 5-11, since the Find & Replace text is the same for each of them. For the remainder, you might use a separate worksheet and run a separate Find/Replace without the ".MatchWholeWord = True".
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 04-07-2014, 01:48 AM
fprm67 fprm67 is offline Multiple replace does not work with 2013 Windows 8 Multiple replace does not work with 2013 Office 2013
Novice
Multiple replace does not work with 2013
 
Join Date: Apr 2014
Posts: 7
fprm67 is on a distinguished road
Default

Thank you Paul.
Ok. The items within the lines 5 and 11 are not the same. Line 5 is to remove the white space at the end of a paragraph, and line 11 is to remove the white space between the opening parenthesis and the blank space before the closing parenthesis.

Another question: I often have to do Find & Replace only within the file that is opend, I would like to know how I could modify the code without saving the file and then go on to do Find & Replace?

Thanks
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple replace does not work with 2013 Replace text in multiple documents? Roscoe Word VBA 7 07-31-2017 04:02 PM
Find and replace No longer work TJH Word 3 03-25-2014 11:33 PM
Multiple replace does not work with 2013 Synchronising Outlook 2013 on multiple PCs paddit Outlook 1 11-06-2013 02:39 PM
Multiple replace does not work with 2013 WORD 2013 - Multiple Reviewers: they are all me. dalyght Word 8 05-29-2013 12:19 PM
Multiple replace does not work with 2013 Highlight and then replace multiple words redhin Word VBA 5 03-05-2013 05:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft