Thread: [Solved] VBA Table – Search All Tables - Find & Replace Text in Table Cell With Specific Background Color
View Single Post
 
Old 09-30-2015, 05:56 AM
jc491's Avatar
jc491 jc491 is offline Windows 7 64bit Office 2013
VBA Novice
  
Join Date: Sep 2015
Location: UK
Posts: 55
jc491 is on a distinguished road
Default
Hi Paul,

this is great! thanks so much - exactly what I needed.

I don't know if word is being funny with me again.

However, when I change the shading color it does not respond

If .Cells(1).Shading.BackgroundPatternColorIndex = wdColorGray05

I was trying to make the cell Shading color light -so its not too strong.

Hence trying to use the RGB values - so I would be able to custom pick a light shade.

Am I doing something wrong with below?

If .Cells(1).Shading.BackgroundPatternColorIndex = wdColorGray05

Other than that its fantastic!
thank you

J
Reply With Quote