Cannot change part of a merged cell
 

I've merged cells B22, C22, D22, E22, F22, G22 to give me 1 cell B22
Also merged B23, C23, D23, E23, F23, G23 to create B23 and this
continues to B31.

I'm trying to clear range B22 to B31 and I've put in this code

'Worksheets("Transfer").Range("B22:B31").ClearCont ents

I get the runtime error 1004 - cannot change part of a merged cell.
I'm able to get the code working on a cell that's not merged but not on
a merged cell. Any work around to this?


--
happyPotter
------------------------------------------------------------------------
happyPotter's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread...hreadid=384873

Cannot change part of a merged cell
 

try

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

Regards,
Jayant

Cannot change part of a merged cell
 

For i = 22 To 31
Range("B" & i).MergeArea.ClearContents
Next i


I would recommend this one.

Regards,
Jayant