Cannot change part of a merged cell

H

happyPotter

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").ClearContents

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?
 
J

jjk

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


I would recommend this one.

Regards,
Jayant
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vb code to clearcontents of a merged cell 8
Error 1004 - Cannot change part of a merged cell. 6
Accessing The Value Of A Merged Cell 9
Deleting contents from merged cells from VBA 3
End If without Block If Error Help 6
How to clear contents of multiple cells in Excel simultaneously 1
copy paste merged cells 0
Merged Cells quirky behavior 5

Top