Hide a Row Based on a Cells Value

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!

Please Login or Register  to view this content.

Thanks for you quick response, but I pasted this into my spreadsheet's code and nothing happens. Does something have to trigger it or should it the row automatically.

A changing value in column A via formula will not trigger any event that a macro will detect to "automatically" perform a function. The only way to "automatically" do this would be to analyze a change at the source of the formula in column A, which you gave no information about.

Understood. below is the formula i'm using.

my formula in "Summary" Sheet for Cell A21 reads: =IF('Rented Equipment'!B$1="Inactive",0,1)

Can I assume that if A21 links to B1 of 'Rented Equipment' then A22 links to B2, A23 links to B3, and so on.

Actually no. For every one row down on the summary tab to go 5 rows over in the rented equipment tab.

For instance: A22 Links to G1 and A23 links to L1 etc...

i have attached my worksheet for reference.

Thanks!

This should do it "automatically". You would put this code in the Rented Equipment Sheet event.

Please Login or Register  to view this content.

this code does work to hide rows on the "summary" sheet when there is a change in the corresponding cell in the "rented equipment" sheet. i can also see, this is exactly what my original post was asking for, but this isn't the end result i am looking for. i apologize for the lack of info. the end result is this: when "rented equipment" sheet cell B1 = "Inactive" then "summary" sheet cell row 21 is hidden. then when "rented equipment" sheet cell B1 = "Active" then "summary" sheet cell row 21 is visible. i would like the row to toggle between visible and hidden.

i really appreciate the assistance and again i apologize for the lack of info in my original post.