Macro to hide rows on a worksheet, based on a cell's value on another worksheet.

I am pretty new to macros. I'll try to explain my issue the best I can.

I need rows 10-20 on worksheet A to hide when the value of D3 on worksheet B is equal to 0, and to automatically unhide those rows when the value is anything greater than 0.
The value of D3 is calculated from various cells on worksheet B, so a user would not physically change D3's value.

Please let me know if I need to explain anything further. Thank you in advance!!

It would be best if we new what ranges affected D3 so we could limit the amount of times the code runs but I understand that may not be possible for you. Try this:

Please Login or Register  to view this content.