thanks !!!!!!!!!!!
------------------------------------------------------
"Pete McCosh" wrote:
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
|