title: Macro to copy merged cell to another merged cell whilst keeping the formatting
body: <p>As assisted below, I am currently using </p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Excel.Range)
  Dim src as Range, dest as Range
  Dim mergeAddress as String
  Set src = Range("C9")
  Set dest = Worksheets("FRONT").Range("G7")
  mergeAddress = dest.MergeArea.Address
  If Not Intersect(Target,src) Is Nothing Then
  dest.MergeArea.Cells(1).Value = src.Value
  src.Copy
  dest.PasteSpecial xlPasteFormats
  dest.Parent.Range(mergeAddress).Merge
  End If
  End Sub
  </code></pre>
  
  <p>I am still losing the formatting with this code, e.g. bold, colour etc. </p>
  
  <p>Any help would be appreciated. Thank you. </p>