![]() |
|
|
|
#1
|
|||
|
|||
|
Not very elegant but try this:
Sub MacroFindAndDeleteAllButFirst1() Dim Word Dim Page CurrentPage = Selection.Information(wdActiveEndPageNumber) Selection.HomeKey Unit:=wdStory Page = InputBox("What Page is it on?", "Page Number") Word = InputBox("Enter Word to Delete", "Keep The first") Selection.GoTo What:=wdGoToPage, Count:=Page Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting Selection.Find.Replacement.Font.Color = wdColorRed With Selection.Find .Text = Word .Replacement.Text = Word .Forward = True '.Wrap = Forward .Format = True .MatchCase = False .MatchWholeWord = False .MatchByte = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Replace:=wdReplaceOne Selection.Find.ClearFormatting Selection.Find.Font.Color = wdColorAutomatic Selection.Find.Replacement.ClearFormatting With CurrentPage With Selection.Find .Text = Word .Replacement.Text = "" .Forward = True .Wrap = Forward .Format = True .MatchCase = False .MatchWholeWord = False .MatchByte = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With End With Selection.Find.Execute Replace:=wdReplaceAll Selection.Find.ClearFormatting Selection.Find.Font.Color = wdColorRed Selection.Find.Replacement.ClearFormatting Selection.Find.Replacement.Font.Color = wdColorAutomatic With Selection.Find .Text = Word .Replacement.Text = Word .Forward = True .Wrap = wdFindContinue .Format = True .MatchCase = False .MatchWholeWord = False .MatchByte = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Replace:=wdReplaceAll MsgBox Word + " deleted on the selected page except for the first occurrence" End Sub Last edited by kilroy; 07-08-2019 at 01:06 PM. Reason: Mis read the requirements |
|
| Tags |
| page count, search and replace |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Search for lines that DO NOT have specific character
|
knpaddac | Word | 1 | 01-14-2019 01:16 PM |
Macro to search for specific words in a document
|
mike0215 | Word VBA | 2 | 11-28-2017 07:25 AM |
| Search for specific data in a text string | teligence | Excel | 1 | 05-20-2017 11:51 AM |
Search for multiple texts in cell, return specific text
|
mariur89 | Excel | 4 | 12-14-2014 01:33 AM |
Search first section for specific string...
|
donaldadams1951 | Word VBA | 4 | 03-14-2014 11:24 AM |