title: how to paste only values in excel
body: <p>I'm quite new to Excel and completely new to this forum.</p>
  
  <p>I have taken the code from the below forum and modified it to my need.</p>
  
  <p><a href="http://pressf1.pcworld.co.nz/showthread.php?90122-Creating-Macro-to-copy-and-paste-data-into-the-next-empty-column" rel="nofollow">http://pressf1.pcworld.co.nz/showthread.php?90122-Creating-Macro-to-copy-and-paste-data-into-the-next-empty-column</a>.</p>
  
  <pre class="lang-vb prettyprint-override"><code>Sub copyTotals()
      Dim TargetSht As Worksheet, SourceSht As Worksheet, SourceRow As Integer, SourceCells As Range
      Set SourceSht = ThisWorkbook.Sheets("DUN - Jan")
      Set TargetSht = ThisWorkbook.Sheets("DUN Jan - Jan,Feb,Mar,Apr")
      Set SourceCells = SourceSht.Range("L36,N36")
      If TargetSht.Range("C11").Value = "" Then
          SourceRow = 1
      ElseIf TargetSht.Range("C41") &lt;&gt; "" Then
          MsgBox ("The sheet is full, you need to create a new sheet")
      Else
          SourceRow = TargetSht.Range("C41").End(xlUp).Row + 1
      End If
  
      SourceCells.Copy TargetSht.Cells(SourceRow, 3)
  End Sub
  </code></pre>
  
  <p>The problem is that the values pasted have the formating of the source and i only want to paste the values.</p>
  
  <p>Can someone please help me with this.</p>