Target.Value help in Worksheet_Change

[ProspectiveCounselor]

what's the goal of

        Case "" '
            Target.Interior.ColorIndex = 0
            Target.Font.Color = RGB(0, 0, 0)
            Range(Target.Address).UnMerge

Well, Case "" represents the deletion of cell contents, so it's supposed to set the background to no color and the font color to black, and then it's supposed to unmerge the cells. The background and font colors are changing only on the already unmerged cells, though.

Hi

add this line above the Select case statement

If Target.Cells.Count > 1 Then Exit Sub

this will allow to exit the sub while working on multiple cells.

Thank you, that worked.