I am having trouble with this piece of code. I can't seem to make these two
variable work together. If I remove the "And Like "*me*" portion of the If
statement then the code will change the color correctly in the merged cells
but I can't seem to get the 'And' piece to work. Can anyone help?
Sub Customer_Colors()
For Each c In Range("B8:IT500")
If c.MergeCells = True And c.MergeCells Like "*something*" Then
c.Interior.ColorIndex = 4
Next
End Sub
Thanks
Carrie
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200801/1