title: How can I update text in a merged cell with VBA?
body: <p>Suppose I have 2 cells that are merged, lets say <code>Sheet1!$A$1:$B$1</code>.</p>
  
  <p>And lets say there's a piece of text that's centered across both cells.  How do I programmatically update that value with VBA? I have a simple user form with a button, on button click, I want the cell to update.</p>
  
  <p>I've tried grabbing the Range, but that doesn't seem to work.</p>