Macro to change an RGB table cell shading color to another RGB color

		Microsoft Office Forums > Microsoft Word > Word VBA
Macro to change an RGB table cell shading color to another RGB color

FAQ

Thread Tools

Display Modes

05-24-2018, 02:29 PM

David Matthews David Matthews is offline

Windows 7 64bit Macro to change an RGB table cell shading color to another RGB color

Office 2016

Novice

Join Date: May 2018

Posts: 6

David Matthews is on a distinguished road

This is all I've found so far. It does not work for me.

Sub test()
Dim rg As Range
Set rg = ActiveDocument.Range
With rg.Find
.Format = True
.Text = ""
.Font.Shading.BackgroundPatternColor = RGB(225, 225, 153)
.Replacement.Text = ""
While .Execute
rg.Font.Shading.BackgroundPatternColor = RGB(225, 225, 225)
rg.Collapse wdCollapseEnd
Wend
End With
End Sub

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to change the font color of specific text within a Word table cell	epid011	Word Tables	2	05-15-2017 05:21 PM
looking to change cell color by typing number into the cell	ibs	Word Tables	1	11-22-2016 06:31 PM
How to change the font color of cell values	sky474	Excel	7	03-06-2014 09:15 AM
Change Cell Color Based On % Complete	jrfoley3	Project	1	05-30-2013 05:24 AM
Creating a Macro to change the shading of a cell	Triscia	Word VBA	3	01-30-2013 04:18 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:13 PM.