Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 11-15-2015, 02:17 PM
kristib kristib is offline Macro to color row of Word table based on found text Windows 8 Macro to color row of Word table based on found text Office 2013
Novice
Macro to color row of Word table based on found text
 
Join Date: Nov 2015
Posts: 3
kristib is on a distinguished road
Default

Thank you so much for replying. I used your exact code, except I replaced the Find text with my actual text. I am getting a Run-time error 5560: The Find What text contains a pattern match expression which is not valid.

My code below:

Sub Demo()
Application.ScreenUpdating = False
With ActiveDocument.Range
With .Find
.ClearFormatting
.Replacement.ClearFormatting
.Text = "{Sat Breakfast}"
.Replacement.Text = ""
.Forward = True
.Wrap = wdFindStop
.Format = False
.MatchWildcards = True
.Execute
End With
Do While .Find.Found
If .Information(wdWithInTable) = True Then
.Rows(1).Shading.BackgroundPatternColorIndex = wdYellow
'.Delete
End If
.Collapse wdCollapseEnd
.Find.Execute
Loop
End With
Application.ScreenUpdating = True
End Sub

Any other ideas?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to color row of Word table based on found text Inserting a Merged Row after a certain text is found in a table Snaybot Word VBA 13 09-30-2015 03:12 PM
Macro to color row of Word table based on found text Table, font color based on what word is in cell donaldadams1951 Word Tables 1 04-15-2015 08:37 PM
Color-fill a range of cells, based on text in a different sheet. Possible? unittwentyfive Excel 2 06-01-2014 06:48 AM
Macro to color row of Word table based on found text Word VBA Macro to Find and Replace based on the Alt Text of an Image bennymc Word VBA 1 01-27-2014 04:23 PM
Macro to color row of Word table based on found text Word 2003 - Macro to color a row in table? cyberpaper Word 2 01-03-2013 02:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:44 PM.


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