Please Note: This article is written for users of the following Microsoft Word versions: 97, 2000, 2002, and 2003. If you are using a later version (Word 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Word, click here: Noting Table Rows Containing a Character.
Written by Allen Wyatt (last updated November 20, 2021)
This tip applies to Word 97, 2000, 2002, and 2003
Heidi has fifteen documents, each comprised chiefly of one long table. She needs to create a macro to search row-by-row and somehow highlight (either by shading, bolding, changing font, etc.) any row that doesn't have a parenthesis character anywhere in the row. Alternatively, she can also highlight rows that do contain a parenthesis character—she just needs to be able to distinguish between rows that do and rows that don't.
There are many ways that such a macro could be approached, but one that searches for an opening or closing parenthesis is relatively easy. The following example will do the search, row by row, and if either character is found, it will highlight the row by making the background yellow.
Please Note:
This article is written for users of the following Microsoft Word versions: 97, 2000, 2002, and 2003. If you are using a later version (Word 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Word, click here:
Sub HilightRows()
Dim TargetText1 As String
Dim TargetText As String
Dim oRow As Row
Dim iCol As Integer
'initialize the target characters to find
TargetText = "("
TargetText1 = ")"
'Make sure we're in a table
If Selection.Information(wdWithInTable) Then
'Clear all the old shading
Selection.Tables(1).Shading.BackgroundPatternColor = wdColorWhite
'do all the rows
For Each oRow In Selection.Tables(1).Rows
If InStr(oRow.Range.Text, TargetText) > 0 Then _
oRow.Shading.BackgroundPatternColor = wdColorYellow
If InStr(oRow.Range.Text, TargetText1) > 0 Then _
oRow.Shading.BackgroundPatternColor = wdColorYellow
Next oRow
End If
End Sub
Note:
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (568) applies to Microsoft Word 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Noting Table Rows Containing a Character.
The First and Last Word on Word! Bestselling For Dummies author Dan Gookin puts his usual fun and friendly candor back to work to show you how to navigate Word 2013. Spend more time working and less time trying to figure it all out! Check out Word 2013 For Dummies today!
Depending on the type of data you have in your table, the SUM(ABOVE) function might return incorrect results. Here's an ...
Discover MoreWant to move a row in a table very easily? You can do so by using the same editing techniques you are already using.
Discover MoreNeed a way to make sure your text fits within the space available in a table cell? Word has a handy setting that will ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.
Visit the WordTips channel on YouTube
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2024 Sharon Parq Associates, Inc.
Comments