How to hide entire row if value is zero

Probably a very stupid question, but I am looking to make rows appear only if they have a value in column d. I would like for it to automatically make the rows hide and unhide each time values are changed. Is this a possibility? If so, how can I do it? Thanks for your time.

Put this in the code module for the sheet of interest and a row will be hidden every time that the entry in column D is removed. I'm not sure about this kind of routine. It is an awful lot of hassle to re-enter something in column D. Perhaps Autofilter would be another way to get what you want.

Please Login or Register  to view this content.

P.S. This checks if there is a value in column D, I just noticed that the title said if value is zero. Which do you want to trigger the hiding, no value in column D or zero in column D?

I just realized that there are some rows that will have zero values that do not need to be hidden because they are headers. Is there a way to hide individual rows if the value of cell D is zero?

If you can accuratly define the conditions, sure. It's easier in VB to distinguish between an empty cell and one containing 0.