I want to clear the contents of cells with no color. When I run the following code, I get "Cannot change part of a merged cell." error. Any suggestion would be greatly appreciated. Thank you.
Dim c As Range
For Each c In ActiveSheet.UsedRange
If c.Interior.ColorIndex = xlNone Then c.ClearContents