CELL.MergeArea.ClearContents

Mike F
"Sunil" wrote in message
...
How do you code to clear contents of a merged cell

I am trying

If CELL.Interior.ColorIndex = 36 Then CELL.ClearContents

i get an error if the cell is merged with the next cell (e.g B5 and C5)