title: Exclude some columns while copying one row to other
body: <p>I want to copy contents of one row in Excel to other row.  </p>
  
  <p>Currently, I am using following code for copying data from previous row.</p>
  
  <pre><code>rngCurrent.Offset(-1).Copy
  rngCurrent.PasteSpecial (xlPasteValues)
  </code></pre>
  
  <p>but I want to skip some columns. So let's say if there are 20 columns, I want to copy all columns except column 4 and 14. How can this be achieved in VBA?</p>
  
  <p>Example:</p>
  
  <p>Assume following is the data in row.  </p>
  
  <pre><code>Row to be copied........&gt; 1 2 3 4 5 6 7 8 .... 14 15 16  
  Target Row Before Copy..&gt; A B C D E F G H .... N  O   P
  Target Row After Copy...&gt; 1 2 3 D 5 6 7 8 .... N  15 16  
  </code></pre>
  
  <p>So everything is copied except column 4 and 14. Note that original values D and N in column 4 and 14 of Target row are preserved.</p>