Excell - VBA

[blazblaz]

I have 300 rows data, and sorting it descending according column A. The value in column A can be 1,or 0. After sorting I want to hide all rows where the value in A is 0. Because I've sorted it as descending, I want to hide rows from first row where the column A is 0, to 65536. How can I find the first row and describe it in VBA ?

Thaanks for help

 

[GlennUK]

Why don't you use filtering, i.e. menu command Data/Filter/Autofilter?



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[KenWright]

If you are doing this manually then I would take Glenn's suggestion, and if you are doing it in VBA I would also take Glenn's suggestion, eg:-

Sub Filter0()
    With Columns("A:A")
        .AutoFilter Field:=1, Criteria1:="<>0", Operator:=xlAnd
    End With
End Sub

Regards
Ken...........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

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