Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-02-2018, 11:15 AM
kvnrao kvnrao is offline multiple find and replace in vba for special words Windows 10 multiple find and replace in vba for special words Office 2016
Novice
multiple find and replace in vba for special words
 
Join Date: Nov 2018
Posts: 4
kvnrao is on a distinguished road
Default Find Replace

Thank you all, for your proactive suggestions. I could solve it taking reference to your ideas.
Solved program is like this

Sub FiRe()
Application.ScreenUpdating = False
Dim Tbl As Table, FndList, RepList, i As Long
FndList = Array(ChrW(257), ChrW(275), ChrW(299), ChrW(333), ChrW(363))
RepList = Array("A", "E", "I", "O", "U")
Selection.HomeKey Unit:=wdStory
With ActiveDocument

With Selection.Find
For i = 0 To UBound(FndList)
.Text = FndList(i)
.Replacement.Text = RepList(i)
.Execute Replace:=wdReplaceAll
Next
End With


Application.ScreenUpdating = True
End With

End Sub

Thank you all once again
Reply With Quote
Reply

Tags
find and replace, vba in microsoft word, vba in word



Similar Threads
Thread Thread Starter Forum Replies Last Post
multiple find and replace in vba for special words VBA Find&Replace all bold, itlaic, underlined and highlighted words/characters Kalü Word VBA 22 04-24-2018 05:35 AM
multiple find and replace in vba for special words Find and replace mutiple spaces between lowercase words only Dave T Word VBA 2 07-16-2015 11:23 PM
multiple find and replace in vba for special words how to replace to words with multiple formats cdk270 Word 1 07-16-2015 01:56 AM
multiple find and replace in vba for special words Highlight and then replace multiple words redhin Word VBA 5 03-05-2013 05:42 AM
multiple find and replace in vba for special words Find & Replace: substitute red-coloured words with underscores tinfanide Word 2 10-06-2012 11:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:47 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