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!