VBA: How do I clear contents of merged cell?

[Badnames]

Hey,

I'm running a Basic Macro just to clear contents of cells. When i run it I receive an error that I cannot modify merged cells. How can I clear merged cells?

Sub servicesub()
Worksheets("Sheet1").Range("A13:O23,R26").ClearContents
Worksheets("Sheet2").Range("A13:J22,M25").ClearContents
Worksheets("Sheet3").Range("A13:J22,M26").ClearContents
Worksheets("Sheet4").Range("A13:I20,L23").ClearContents
End Sub

 

[morleyuk]

When you merge cells the reference becomes the reference of the top left cell.

So A13:O23 is really just A13

 

[Badnames]

Thanks I'll give that a go. I did a search on merged cells/vba. Looks like they cause a lot of problems.

 

[VoG]

Looks like they cause a lot of problems.

They certainly do. See this similar thread http://www.mrexcel.com/forum/showthread.php?t=580608

 

[Badnames]

So got it to work on all my cells except R26. R26 is merged with R27. I chose R26 here, then tried with R27, but no luck.

 

[Badnames]

Thanks for the link VoG. On a side note, I could use a Tanq martini right now.