title: Macro VBA : What is wrong with my code ? Row delete
body: <p>I am trying to delete the entire row if any cell in column A is blank.</p>
  
  <p>Also this code should run on two specific sheets only (i.e. "ATM SLA Availability Report" &amp; "Incident Report") within the same workbook.</p>
  
  <p>Below is my code. It gives me Run-Time error 9 when I run it.</p>
  
  <pre><code>Sub test()
      Worksheets("ATM SLA Availability Report").Range("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete shift:=xlUp
      Worksheets("Incident Report").Range("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete shift:=xlUp
  End Sub
  </code></pre>