Unhide rows based on cell value

Hi guys,

I want to build a macro that will unhide rows (33:72) based on the value in one of two cells - B20 or B21 (it has to be mentioned that the cells in question contain formulas, so the value in them depends on other cells. If the value in cell B20 is > 0 the value in cell B21 is 0 and vice versa. So it is important that the macro is automatically triggered by a change in those cells).
The possible values in cell B20 are 1 to 25 and the possible values in cell B21 are 1,2,5,15 or 25.

So what I want the macro to do is - when the value in either B20 or B21 is a certain number to unhide that amount of rows. For example it is "1" - unhide row 33. If it is "2" - unhide rows 33 and 34.

Thank you very much! Your help is highly appreciated!

Best regards,
Alex

Thank you for your answer. The problem is that I already have the code below and I get an error and the workbook crashes.

Please Login or Register  to view this content.