Show Hide Rows based on cell value

Dear All

What I am trying to achieve:

I am trying to show / hide rows A11 through A20 but based on the result of the formula in cells A11 through A20, The formula is a simple If Formula [=IF(D11="",1,0)] basically if anything is typed in cells D11 through D20 changes the formula then when code runs shows / hides the respected rows.

This is the code i have so far: ( which seems to work )

Please Login or Register  to view this content.

However

If the code is run and say Rows D11 & D12 have data in the cells, so they are visible and the rows D13 through D20 are hidden as there is no data in these cells. Then you change say D12 to have no data in the cell, the formula changes ok but when you run the code the code now hides this row when it should according to the formula show it. ( So you get the opposite happening ).

I need a way where the code opens all rows no matter what there state then hides rows based on the cell value of A11 through A20.

Example:

So Currently Rows A11 through A20 = Hidden ( As no data in D11 through D20 )

Button Press = Rows A11 through A20 = Shown

Then you enter data in D11 and D12

Button Press = Rows A11 through A20 = Hidden ( subject to formula result )

What i would like it to do:

If at this point you now clear D12 of data. ( Formula Updates )

Button Press = Rows A11 through A20 = Shown ( ignoring formula result, must show all rows ) THIS CURRENTLY DOES NOT HAPPEN IT HIDES ROW D12.

Button Press = Rows A11 through A20 = Hidden ( subject to formula result )


I have uploaded the excel file for ease.

Thanks in advance

Juicy

Try this code here. Changes highlighted in red

Please Login or Register  to view this content.

Hello guys!
quekbc's code works fine but if you accept a suggestion, I would replace:

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.