title: xlPasteValues not reflecting copied contents
body: <p>I'm trying to copy the values on a certain range to another range but the <code>xlPastValues</code> function is not reflecting the contents I'm copying. There's no error, it's just showing blank cells on <code>F6</code> my range. Please help. </p>
  
  <pre><code>    With Worksheets(4)
      '[D4] Main date
      Worksheets(4).[J1].Value = Worksheets(1).[D4]
      '[J6:J31] holds formulas to calculate certain dates
      Worksheets(4).[J6:J31].Copy
      Worksheets(4).[F6].PasteSpecial Paste:=xlPasteValues
      Application.CutCopyMode = False
  End With
  </code></pre>