Thread: [Solved] Numeric Values
View Single Post
 
Old 11-09-2014, 12:41 PM
gmaxey gmaxey is offline Windows 7 32bit Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,601
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

Try:

Code:
Sub ScratchMacro()
'A basic Word macro coded by Greg Maxey
Dim oRng As Word.Range
  Set oRng = ActiveDocument.Range
  With oRng.Find
    .ClearFormatting
    .Text = "[0-9]{1,3}[ .,']{1}[0-9]{3}.[0-9]{2}"
    With .Replacement
      .Text = ""
      With .Font
        .ColorIndex = wdRed
        .Size = 18
      End With
    End With
    .Format = True
    .MatchWildcards = True
    .Execute Replace:=wdReplaceAll
  End With
End Sub
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote