Delete & Hide Rows in a Worksheet based on the Value of a Cell in another Worksheet

[lhickerson]

I have a workbook that contains two sheets. The first Sheet is "Sheet A", the Second is "Sheet B". I want Rows 34 thru 45, 147 thru 160 to delete automatically in Sheet B and Rows 203 thru 208 and Rows 211 thru 221 to be hidden when on the Value of Cell C16 in Sheet A is "YES". Can you help me write a VBA module for this? Thanks.

[JBeaucaire]

This is an even macro that goes in the Sheet A sheet code module. Right-click Sheet A tab and select VIEW CODE, then paste in this code:

Please Login or Register  to view this content.

,
Note - I find this requested code to be extremely dangerous. Once you delete rows 34:45, 147:160, the rows 203:208, 211:221 are no longer in those row positions. If you do anything to edit C16, even just typing YES again in that cell, it will delete the CURRENT 34:45, 147:160 rows again. Very dangerous code.

[lhickerson]

Thank you - this worked perfectly and I appreciate the heads up about the type of code. I have one other question - if I want to add another Sheet "Sheet C" to Hide Rows 67 thru 89 with this same condition - how can I modify the code?