View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Richard[_34_] Richard[_34_] is offline
external usenet poster
 
Posts: 12
Default ClearContent & 'Cannot change part of a merged cell' error

Works great !

But it seems I get a Run-time error 1004 "Application-Defined or
object-defined error" with groups of merged cells.

For instance, if cells A1 & A2 are merged, and cells B1 & B2 are
merged, the errors appears because tSel_Group represent A1:B2 ... which
is 2 groups of merged cells.

Any workarounds for such ?

THANKS !
Richard