VBA: Hiding rows with columns values of 0.00

elburgess · Sep 5th 2003

Have a sheet with 0.00 in column D

My normal routines for hiding rows with a cell value of 0 do not provide the result needed.

Earl

lambuhere1 · Sep 5th 2003

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
Rows(i).Select
Selection.EntireRow.Hidden = True
End If

Next i

End Sub

elburgess · Sep 5th 2003

Recieve error 91 "Object variable or with block variable not set":barf:

VBA: Hiding rows with columns values of 0.00

Participate now!

Share