![]() |
|
#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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
knpaddac | Word | 1 | 01-14-2019 01:16 PM |
![]() |
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 |
![]() |
mariur89 | Excel | 4 | 12-14-2014 01:33 AM |
![]() |
donaldadams1951 | Word VBA | 4 | 03-14-2014 11:24 AM |