excel macro format merged cells
Sub test2() Dim c As Range For Each c In Selection If c.MergeCells Then c.Interior.ColorIndex = 19 Next End Sub
Source: www.mrexcel.com
Sub test2() Dim c As Range For Each c In Selection If c.MergeCells Then c.Interior.ColorIndex = 19 Next End Sub