Macro to hide rows

[jparadise81]

I need a macro that will automatically hide a row if cell A1 equals 0. I tried using the filter function but it will not unhide the row if the value in cell A1 changes from 0. BTW, cell A1 is linked to another cell on a different sheet.

Thanks in advance!

[mshale]

Which row would you like to hide if cell A1 = 0? Will A1 be the comparisson for all of the rows being hidden? You say you are using a filter, what row is the header row?

Or are you trying to hide rows that have a value of 0 in that row, column A? In that case, what is the header row?

[mshale]

Well, this is a stab in the dark, but I'm guessing it's the second situation and the header row is in row 1.

Please Login or Register  to view this content.

That code autofilters to show you all non-zero values in column A. You will need to place this in the worksheet object in the left pane of the Editor (double-click to open that object).