title: Copy and pasting between excel workbooks
body: <p>I have a Macro that copies and pastes from one excel document to another. For some reason, I had an error when using pastespecial immediately after copying and pasting from the other source doc. So as a workaround I just pasted normally, and then copied it again and then used pastespecial. My problem is that when running this Macro for some reason it adds a space to the end of the numbers turning them into text. Meaning that my graphs don't recognize them. </p>
  
  <pre><code>Workbooks.Open (fileLocation &amp; "/" &amp; fileName &amp; fileType)
  Worksheets(sourceWorksheet).Select
  rowInUse = 46           'Add data row and name of sheet being imported into
  mySheet = "sheet2"
  pasteLocation = "D5"
  lastColumn = ActiveSheet.Cells(rowInUse,     Columns.Count).End(xlToLeft).Column
  Range(Cells(rowInUse, firstColumn), Cells(rowInUse, lastColumn)).Copy
  ActiveWorkbook.Close SaveChanges:=False
  Worksheets(mySheet).Select
  Range(tempPasteLocation).Select
  ActiveSheet.Paste
      Sheets(mySheet).Select
      Range(tempPasteLocation, Cells(tempRow, tempColumn + lastColumn)).Select
      Selection.Copy
      Range(pasteLocation).Select
      Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
          False, Transpose:=True
  Range(tempPasteLocation, Cells(tempRow, tempColumn + lastColumn)).Select
  Selection.ClearContents
  </code></pre>
  
  <p>Does anyone have any idea why this is happening or how to fix it?</p>
  
  <p>Thank you</p>