VBA to hide/show rows, if column B is blank

I have created a cashflow template that can be used for any size job in terms of line items (Y Axis) and duration (X axis). I have written VBA to hide/show cells, but I would like to create button that when selected will hide/show all rows if that row's B cell is blank I.E. will not be used. This would be optimal as it would clean up my table to only show actively used line items. I have tried to write this code a couple different ways, but have gotten tripped up when it comes to accounting not only for blank cells in row B, but when the cells are populated and I still "lose" them. Any direction/advice would be very appreciated.

Thanks for the help, and the warm welcome! The one issue with the code above is that (and this is partially on me for not explaining properly) the rows to be hidden per the blank cells... These cells are pulled from another source so they aren't actually blank, and excel reads them as a 0 "-". Is there a quick adjustment I can make for this to be processed properly?

I have found a solution.

This will run and hide all rows when the cell in column B=0. When more data is added and more lines become populated, it can be run again and the new data will appear

PHP Code: 

Sub ShowUsedRowsPerItemCell()
    BeginRow = 6
    EndRow = 401
    ChkCol = 2

    For RowCnt = BeginRow To EndRow
        If Cells(RowCnt, ChkCol).Value = 0 Then
            Cells(RowCnt, ChkCol).EntireRow.Hidden = True
        Else
            Cells(RowCnt, ChkCol).EntireRow.Hidden = False
        End If
    Next RowCnt
End Sub 


I have battles with "blank" cells everyday Thanks for everything! :D