macros: clear cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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