title: Delete rows X to Y in on a specific Excel Worksheet
body: <p>I am writing a VBScript which opens an Excel file, deletes rows <code>X</code> to <code>Y</code>from a specific Sheet then saves and closes the file. The opening and closing part I have down however deleting part is what I am struggling with.  <code>X</code> and <code>Y</code> are fixed, say rows 6 to 10. </p>
  
  <pre><code>Set objExcel=CreateObject("Excel.Application")
  
  objExcel.Visible = True
  
  Set wb = objExcel.Workbooks.open("FILE_ADDRESS")
  
  Set ws = wb.Sheets(1)
  
  ws.Rows(2).Delete
  
  wb.Save
  wb.Close
  
  objExcel.Quit
  </code></pre>