macros: clear cell

C

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?
 
J

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.
 
Top