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.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
In Excel it is easy to count how many times a certain character occurs in a column of cells. In Word, it is a bit ...
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 to jump from one end of a table row to another? Word provides a couple of handy shortcuts that can make this type of ...
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