| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell is merged and contains "something"
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell is merged and contains "something"
On 18 Jan., 00:20, "Carrie_Loos via OfficeKB.com" <u34134@uwe wrote:
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.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-programming/200801/1 Hi Carrie Try this Sub Customer_Colors() For Each c In Range("B7:IT50") If c.MergeCells = True And c.Value Like "*something*" Then c.Interior.ColorIndex = 4 Next End Sub Regards, Per |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell is merged and contains "something"
I am still having the same issue - any other ideas?
Per Jessen wrote: 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 [quoted text clipped - 17 lines] -- Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-programming/200801/1 Hi Carrie Try this Sub Customer_Colors() For Each c In Range("B7:IT50") If c.MergeCells = True And c.Value Like "*something*" Then c.Interior.ColorIndex = 4 Next End Sub Regards, Per -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200801/1 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell is merged and contains "something"
My mistake, works well. Thanks
Per Jessen wrote: 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 [quoted text clipped - 17 lines] -- Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-programming/200801/1 Hi Carrie Try this Sub Customer_Colors() For Each c In Range("B7:IT50") If c.MergeCells = True And c.Value Like "*something*" Then c.Interior.ColorIndex = 4 Next End Sub Regards, Per -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200801/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| How to find non-blank cell values "hidden" under merged regions? | Excel Discussion (Misc queries) | |||
| "Cannot change part of a merged cell" when AutoFilter is turned on | Excel Programming | |||
| "Cannot Change Part of a Merged Cell" When updating link using mac | Excel Programming | |||
| Convert "merged" cells to "CenterAcrossSelection" | Excel Programming | |||
Linear Mode
