Question on Hiding Row Conidtionally

[trm1838]

Hi

I want VBA to hide rows conditionally based on a column in that row being equal to 0, but i want it to automaticallly include all active rows with data in the spreadsheet instead of entering a range. Then i want it to sort the data in descending order. Any help would be great.

 

[erik.van.geit]

Hi, trm1838
Welcome to the Board !!!!!

Some suggestions to start with:
Do you know about the tools AutoFilter & Sort in the menu Data ?
Do you know about the macro recorder ?

when recording a macro, you'll get something like this

Sub Macro1()

    Range("A1:C10").Select
    Selection.AutoFilter
    Selection.AutoFilter Field:=1, Criteria1:="<>0", Operator:=xlAnd
    Selection.Sort Key1:=Range("A1"), Order1:=xlDescending, Header:=xlGuess, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
        DataOption1:=xlSortNormal
End Sub

a few edits
recoreded macro has all arguments
one of them is "Header" recorded result:=xlGuess
if there are headers then you need Header:=xlYes, if not xlNo
I assume there are headers

Sub Macro1_edit1()

    With Range("A1:C10")
    .AutoFilter
    .AutoFilter Field:=1, Criteria1:="<>0", Operator:=xlAnd
    .Sort Key1:=Range("A1"), Order1:=xlDescending, Header:=xlGuess, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
        DataOption1:=xlSortNormal
    End With

End Sub

this is what we call hardcoding
now you can do a search for "lastrow" to see how you would edit this to change "10" to the real last row

kind regards,
Erik