Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-12-2015, 07:05 PM
gmaxey gmaxey is offline How to highlight lines containing specific words Windows 7 32bit How to highlight lines containing specific words Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,598
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

Someone may be allow with a simplified find and replace, but it is late here:



Code:
Sub ScratchMacro()
'A basic Word macro coded by Greg Maxey
Dim oPar As Paragraph, oRng As Range
  For Each oPar In ActiveDocument.Range.Paragraphs
    Select Case Trim(oPar.Range.Words.First)
      Case "Sunday", "Monday", "Friday"
        Select Case True
          Case IsNumeric(oPar.Range.Words.Last.Previous)
            Set oRng = oPar.Range.Words.Last.Previous
            oRng.MoveStart wdCharacter, -3
            If IsNumeric(oRng) Then
              oPar.Style = "Body Text" 'Define some style you want to apply.
              
            End If
        End Select
    End Select
  Next oPar
lbl_Exit:
  Exit Sub
End Sub
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #2  
Old 06-12-2015, 10:16 PM
SixStringSW SixStringSW is offline How to highlight lines containing specific words Windows XP How to highlight lines containing specific words Office 2000
Novice
How to highlight lines containing specific words
 
Join Date: Jun 2015
Posts: 2
SixStringSW is on a distinguished road
Default

Quote:
Originally Posted by gmaxey View Post
Someone may be allow with a simplified find and replace, but it is late here:

Code:
Sub ScratchMacro()
'A basic Word macro coded by Greg Maxey
Dim oPar As Paragraph, oRng As Range
  For Each oPar In ActiveDocument.Range.Paragraphs
    Select Case Trim(oPar.Range.Words.First)
      Case "Sunday", "Monday", "Friday"
        Select Case True
          Case IsNumeric(oPar.Range.Words.Last.Previous)
            Set oRng = oPar.Range.Words.Last.Previous
            oRng.MoveStart wdCharacter, -3
            If IsNumeric(oRng) Then
              oPar.Style = "Body Text" 'Define some style you want to apply.
              
            End If
        End Select
    End Select
  Next oPar
lbl_Exit:
  Exit Sub
End Sub
Thanks, I'll give it a try!
Reply With Quote
Reply

Tags
formatting, regex



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to highlight lines containing specific words VBA to highlight words if used too much aolszewski Word VBA 3 11-23-2013 02:07 AM
How to highlight lines containing specific words Highlight all underlined words zdodson Word VBA 1 07-11-2013 04:53 PM
How to highlight lines containing specific words Macro to highlight words bertietheblue Word VBA 9 07-01-2013 12:39 PM
How to highlight lines containing specific words Highlight and then replace multiple words redhin Word VBA 5 03-05-2013 05:42 AM
How to highlight lines containing specific words Find and highlight all words ending in -ly RBLampert Word VBA 13 10-23-2012 04:45 PM

Other Forums: Access Forums

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