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

try

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

Regards,
Jayant

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


I would recommend this one.

Regards,
Jayant