Automatic macro

Hi all,

I have a simple macro that I would like to start whenever the value in cell H13 or H14 is changed. I've searched online, but either I'm doing something wrong, or the given answers do not work.

Anyone who knows how to get it going?

This is the macro that should start whenever H13 or H14 is changed:

Sub Hide()

For i = 35 To 106
If Cells(i, 8).Value = 0 Then
Cells(i, 8).EntireRow.Hidden = True
End If
Next i

For i = 35 To 106
If Cells(i, 8).Value > 0 Then
Cells(i, 8).EntireRow.Hidden = False
End If
Next i

End Sub

.
.
For starters, to comply with the FORUM rules, always put your code in the # brackets.

Using this code :

Please Login or Register  to view this content.

I condensed your code a little. Instead of using two of the same, you can use one >= so long as other parts don't change.

See how this works ....

Thanks, but if I use your sheet, Excel hides all rows 35 to 106, whatever the value in column H of a row (for instance add 5 to H50). If you then go to H13 or H14, row 50 is being hidden, while it shouldn't.

I've missed something in your request. I don't understand what you are asking.

Well,

The goal of the macro is to hide all rows from 35 to 106 in which the value in column H is zero. That's why I had the Cells(i,8)-code, which worked. It did what it had to.

Somehow your code no longer does that, as it hides all rows from 35 to 106, whatever the value in column H.

So your code does work 'automatic', which is great, but somehow it lost the goal of the macro.

If the value 0 (zero) is entered in Cell H13 or H14 ? Only those two cells ?

If 0 (zero) shows up in H13 or H14 then rows 35 to 106 should be hidden ?

No, the value of H13 of H14 is irrelevant to determine what rows should be hidden. It is the value in the H-column that determines what rows should be hidden:
for instance: if H36 is 0, then row 36 should be hidden. If H37 is 5, then row 37 should not be hidden, and so on.

A change in H13 or H14 determine when the macro should be executed/started.

Glad to help. If your question is answered please mark this thread Solved.

Merry Christmas !