I am very very new to VB but i'm in need of code that will automatically hide a row based on its value in Column A. My range in column A is A22:A37. If the value in A22 is "0" I would like to hide row 22 all together. The values in A21:A35 are populated by a formula referencing data in another worksheet. I figure this shouldn't be to hard but it's above my knowledge base.

Many Thanks ahead of time!