title: Copy and paste to each new worksheet with formatting and formulas
body: <p>I need your assistance on VBA code to Copy Paste to each new worksheet with formatting and formulas using the range method.
  Here are 2 variations of what I have. One copies and pastes with format but pastes as values and the other retained the formula but not the format. 
  Your assistance is greatly appreciated.</p>
  
  <ol>
  <li><p>This keeps the format but paste as value</p>
  
  <pre><code>rngHeader.Copy Destination:=.Range("A4")
  res.Copy Destination:=.Range("A5")
  </code></pre></li>
  <li><p>This keeps formula but loses the formatting</p>
  
  <pre><code>.Range("A4").Resize(, rngHeader.Columns.Count).Formula = rngHeader.Formula
  .Range("A5").Resize(res.Rows.Count, res.Columns.Count).Formula = res.Formula
  </code></pre></li>
  </ol>