Cannot changed part of a merged cell error

[ipbr21054]

Hi,

Please see screenshots
.
You will see that the 2 cells in question are G49 & G50
This is the simple code im using just to clear cells.
But when i run the code i am told it cant because they are merged ?

Why is this thanks

Private Sub ClearAllPageDetails_Click()
Range("G13").ClearContents
Range("N18").ClearContents
Range("G27:N36").ClearContents
Range("G46:G48").ClearContents
Range("G49").ClearContents
Range("G50").ClearContents
End Sub

 

[ipbr21054]

Panic over.
It is because column H is hidden

Maybe somebody can explain why it then thinks its merged ?
If column G is visable but column H is hidden then surely thats wrong as bothwould then be eith visable or hidden at the same time correct /

 

[RoryA]

No, you can hide one column independently of the other.

 

[ipbr21054]

Strange as like i say you can see column G but you cant see column H or I so why does it say merged ?

 

[RoryA]

Given that the Merge and Center button is highlighted in your picture, it would appear you have merged cells. You can certainly merge cells in columns G and H but hide column H.

 

[ipbr21054]

Many thanks now seen it.