Excel - Macro's

[KugaWestie]

Hi,

 

Anyone any good at writing Macros?

 

I want to be able to hide specific columns or rows that have a zero value in them.

 

Anyone able to help?

[Andy Banks]

Sub HURows()
    BeginRow = 1
    EndRow = 100
    ChkCol = 3

    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

The above from http://excel.tips.net/ Plenty more out there...

[Dave Eastwood (Gadgetman) - Club Chairman]

I like that. TBH, I always think of "wouldn't it be better if..." Ideas like hiding null rows/columns when I'm in the middle of using a spreadsheet, and I've not got the time to research what to do, but that's exactly the sort of thing I could do with building into the main sheets I use.

 

Thanks for the idea! (Threads like this are one of the things I love about the Boardroom, out of the blue solutions to life's little niggles).