View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
jjk jjk is offline
external usenet poster
 
Posts: 42
Default Cannot change part of a merged cell

try

Worksheets("Transfer").Range(*"B22:G31").ClearCont ents

Regards,
Jayant