Hide/Unhide Rows based on value in cell

[onthegreen03]

I know this question gets asked a lot, but I need some help with what I think is simple VBA coding. I have data in column C (rows 8 - 53). Via formula, some of the rows have data and some are blank (""). I need a macro that when run will hide all rows in cells C8:C53 that are blank, AND show all rows that have a value. I plan to create a button that when clicked will hide/unhide those rows based on the current cell value. Thanks for your help!

 

[Joe4]

I know this question gets asked a lot, but I need some help with what I think is simple VBA coding. I have data in column C (rows 8 - 53). Via formula, some of the rows have data and some are blank (""). I need a macro that when run will hide all rows in cells C8:C53 that are blank, AND show all rows that have a value. I plan to create a button that when clicked will hide/unhide those rows based on the current cell value. Thanks for your help!

What not just use Filters to hide the rows based on their value?

 

[onthegreen03]

That is a good option (I always forget about that method). I was hoping to have a button at the top that the user can just click and the rows with values will show and the rows that are blank are hidden. If you think that is overkill/unnecessary I will go with the filter method.

 

[Joe4]

You can create a little VBA code to toggle the filter on and off, and link that code to your button, i.e.

Sub ToggleRows()

    Dim myRange As Range
    
'   Set range to filter on
    Set myRange = Range("C7:C53")

'   If filter is on, shut it off,,,
    If ActiveSheet.AutoFilterMode Then
        myRange.AutoFilter
'   ...otherwise turn it on
    Else
        myRange.AutoFilter Field:=1, Criteria1:="<>"
    End If
    
End Sub

 

[onthegreen03]

Brilliant! Thank you Joe.

 

[Joe4]

You are welcome.
Glad I was able to help!