title: ="" won't delete a row that has a formula attached. Excel
body: <p>I want to delete a row if there is no value in A. If A86 were to have no value and not have &quot;3060&quot; it would delete. Although Something like row 88 has no value in A but it won't delete. Cell D88 has a formula which is ='labor budget breakout'!D97 and it won't delete. I want these cells D:F to be deleted since they have a value of A=&quot;&quot;.</p>
  <pre><code>Sub DeleteRowIfCostCode()
  
  Dim count, i As Long
  
  count = Sheet1.Cells(Rows.count, &quot;A&quot;).End(xlUp).Row
  
  'msgbox count
  
  i = 6
  Do While i &lt;= count
  
  If (Cells(i, 1)) = &quot;&quot; Then
  
  Rows(i).EntireRow.Delete
  i = i - 1
  End If
  
  i = i + 1
  count = Sheet1.Cells(Rows.count, &quot;A&quot;).End(xlUp).Row
  
  Loop
  
  End Sub
  </code></pre>
  <p><img src="https://i.stack.imgur.com/ZyDIQ.png" alt="Displays Worksheet" /></p>