title: Remove cells in Excel which have zero values
body: <p>I have been trying to remove/hide cells which values are equal to zero (0). </p>
  
  <pre><code>Sub HideRows()
      Dim cell As Range, rng As Range
      Cells.Rows.Hidden = False
  
      On Error Resume Next
      Set rng = Columns(5).SpecialCells(xlConstants, xlNumbers)
      On Error GoTo 0
  
      For Each cell In rng
          If cell.Value = 0 Then
              cell.EntireRow.Hidden = True
          End If
      Next
  
  End Sub
  </code></pre>
  
  <p>The code removes the entire row. I want to remove the description of the value and the value.</p>