David,

something like this: just subsitute the number of rows in the For loop and
the values you want to test.

Sub Hide_Unwanted_Rows()

Dim X as Integer

For X = 2 to 100

If cells(x,1).value =0 Then
Rows(x).hidden=true
End if

Next x

End Sub

Cheers, Pete.

"david" wrote:


I need to hide rows depending on whats in the cells (a1,a2,a3,...)

can somewane give me a example of a macro for this.

thank you