Run macro when cell in range changes due to calculations

[NancykAllen]

I have tried to understand other posts on this subject, but I am VERY new to this and don't understand what I am reading. I have the following macro:

Sub Hide_Rows_Services()
Sheets("Services Summary").Select '
Range("i6:i20").Select
For Each cell In Selection
If cell = 0 Then
Range(cell.Address).EntireRow.Hidden = True
Else
Range(cell.Address).EntireRow.Hidden = False
End If
Next
End Sub

Calculations will change the value in I6:I20. When they do change, I need the above macro to run. I have a similar macro on another worksheet that I want to do the same thing.

Sub Hide_Rows_GPM()
Sheets("GPM Summary").Select '
Range("j21:j99").Select
For Each cell In Selection
If cell = 0 Then
Range(cell.Address).EntireRow.Hidden = True
Else
Range(cell.Address).EntireRow.Hidden = False
End If
Next
End Sub

I need someone to guide me through the steps to make this happen. Please respond as if you are talking to a dummy because on this subject I am. I have not training and I am basically teaching myself as I go. Any help will be appreciated.

[HaHoBe]

Hi, NancykAllen,

please feel remineded to put Code-Tags around the codes.

You would need Private Sub Worksheet_Calculate behind the worksheet or monitor the cells which cause the cells to be changed/calculated.

Ciao,
Holger