title: PasteSpecial (Format and Value)
body: <p>I have an excel program/button that creates a table.  The inputs are in a single row/multiple columns on sheet 1. The outputs are the same but on a sheet 2.  The headings on both sheets of the columns are the same.  On the input sheet, one of the column headings has a drop down menu and others have formulas.  When I click a button, the row is copied/pasted to the output sheet. I can repeat the process by selecting different items from the drop down box and pushing the button to run the program to populate the table on sheet 2.  The problem is the I only want to copy and paste values.  Changing the drop down box on sheet 1 changes all of the information on to the same item on sheet 2. </p>
  
  <p>The code is as follow:</p>
  
  <pre><code>Sub AddHardware()
      Range("b5:m6").Copy Sheets("MTO").Range("B" &amp; rows.Count).End(xlUp).Offset(1, 0)                
  End Sub
  </code></pre>
  
  <p>How do I only paste the values and the formatting (no formulas or drop downs)?</p>