title: How to copy data to an existing sheet without losing any data types or formatting
body: <p>Here's the problem. I tried to build a simple regression test.
  I have two sheets linked together and some other vba functionality.
  In order to test regularly, I used copy-move-> make a copy and created precise copy of good sheet a then repeated with good sheetb and took a screenshot of how they should look when working correctly after I run my code.
  All I have to do is copy in this known data, run the code then check the output against my screenshot.  Or so I thought.
  When I ran the code lots of things just changed themselves despite the fact that I a coping a range of data forma clone of this sheet. using </p>
  
  <pre><code>range( a ).value = range( b).value  '(pseudo-code)
  </code></pre>
  
  <p>1 thing  I had column with age/weight  like this 35/12-11  now its formatted as a date and no fiddling with data types can recover it.
  HOW CAN I STOOP eXCEL DOING THIS KIND OF MADNESS?
  next thing the text i.e. names of people in a general column show up as 0 in the destination column.  Why? it is coming from a clone of the one its always come form without a problem.</p>
  
  <p>Can anyone shed light on this. it's devastaing trying to write a olution up agianst this kind of thing, but I''ve already invetsed a lot in it.
  Any help gladly accepted</p>