macro to hide rows

[Guest]

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

 

[Dave Peterson]

I find this an easier alternative:

Apply Data|filter|autofilter to your column (or whole range).

Then use the filter arrow to show/hide the rows you want.

If you've never used autofilter before, Debra Dalgleish has some info at:
http://www.contextures.com/xlautofilter01.html

 

[Guest]

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.

 

[Guest]

thanks !!!!!!!!!!!



------------------------------------------------------