title: Copy excel range and paste only values (pasteSpecial) with skip blanks in VBScript
body: <p>I need to copy some range of excel from a sheet of source excel file and paste it to a sheet of a target excel file by skipping the blank cells copied from the source excel file. </p>
  
  <p>The below code is working fine in VBA, how to write equivalent code in VBScript?</p>
  
  <pre><code>Selection.Copy
  Sheets("Sheet1").Select
  Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
      :=True, Transpose:=False
  </code></pre>
  
  <p>I know the code for paste special with only values is "-4163". Below snippet is working fine in this case, </p>
  
  <pre><code>sourceWorkbook.Worksheets(1).UsedRange.Copy
  targetWorkbook.Worksheets(1).Range("A1").PasteSpecial -4163
  </code></pre>
  
  <p>But i need it to paste values and skip blank copied cells (i.e do not want to overwrite or replace with the cells of copied range). How to achieve this??</p>
  
  <p>Any help will be greatly appreciated </p>