clear contents of cells that are merged using a macro

[Anthony]

i can only clear contents of a cell if they are not merged ,i would like to
be able to clear if they are merged

 

[Bob I]

That's just another reason merged cells should be avoided like the plague.