macros: clear cell

[clear merged cell]

I am trying to run clear cell using 'Sub clearcell' function, but getting
this error message.

Run time error '1004'
Cannot change part of merged cell

Does this mean that I can't run clear function on merged cells?

 

[Joel]

A merged cell from a macro can only be accessed from the top left cell. You
arre probably trying to clear a merge cell from a different cell.