VBA: Hiding rows with columns values of 0.00

  • Try this

    Sub hide_row()
    range_last = Range("A65536").End(xlUp).Row
    For i = 3 To range_last
    If (Cells(i, 4).Value = 0#) Then
    Selection.EntireRow.Hidden = True
    End If

    Next i

    End Sub

    Ram P

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!