(Solved) – Runtime-Error :”We can’t do that to merged cells.”

  • by
(solved)-–-runtime-error-:”we-can’t-do-that-to-merged-cells.”

This is form design I want to use to provide data to a table below and vice-versa.

enter image description here

Sub Cont_New()
With Sheet1
 .Range("R33").Value = True 'Contact Load
 .Range("R32").Value = True 'New Contact to True
 .Range("D7,D9,D11,D13,D15,D17,D19,D27").ClearContents
 .Shapes("ExistContGrp").Visible = msoFalse
 .Shapes("NewContGrp").Visible = msoTrue
 .Range("R33").Value = False 'COntact Load to False
End With
End Sub

How can I solve this issue with the merged cells? Please help, I’m completely new to using VB.

Leave a Reply

Your email address will not be published. Required fields are marked *