title: Paste formats without using ".Copy" + ".Paste"
body: <p>For example:</p>
  
  <pre><code>rngTo.Value = rngFrom.Value2 'Works
  rngTo.NumberFormat = rngFrom.NumberFormat 'Works
  rngTo.Cells.Interior.ColorIndex = rngFrom.Cells.Interior.ColorIndex 'Doesn't work
  rngToPublish.Copy: rNG.PasteSpecial xlPasteFormats ' Does work
  </code></pre>
  
  <p>Is there any way to get this desired effect without using the <code>PasteSpecial</code>?</p>