Private Sub to looking at two different cell changes

[EdwardSurrey]

Is there a way to have a private sub that runs different macros based on different cell changes?

The below code only executes the HideRows macro when I change the value in C11. It will not execute ClearData macro when I change C10. Is there a way to make it work?

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("C11")) Is Nothing Then HideRows
Exit Sub
If Not Intersect(Target, Range("C10")) Is Nothing Then ClearData
End Sub

Thanks

 

[Joe4]

Yes, get rid of the "Exit Sub" row.
Once it hits that, it will never get to the next row.

 

[Ruddles]

Take out the Exit Sub? It's stopping the C10 test from ever being executed.

 

[EdwardSurrey]

Thanks. I thought I already tried that! Somehow it's now working. Strange

 

[Joe4]

You are welcome.
Glad we could help!

Typically, you see the "Exit Sub" line in code where you are checking for a particular condition, and if that condition is NOT met, you want to exit the code without doing anything else.