Combining Multiple Worksheet Change Events

[Paul_11]

Hi,

I am new to VBA and am having some trouble combining two worksheet change events.

As I understand you can only have one event per worksheet.

One macro hides rows 8:9 if cell E14="" and unhides if otherwise.

The other macro would hide rows 20:21 if cel E15="" and unhide if otherwise.

How can I combine these two change events?

 

[dmt32]

Hi,
Welcome to forum.
Its always helpful if you post code you have but to give some idea, something like following may do what you want:

 Private Sub Worksheet_Change(ByVal Target As Range)    
   If Not Intersect(Target, Me.Range("E14:E15")) Is Nothing Then
        Me.Rows("8:9").EntireRow.Hidden = Me.Range("E14").Value = ""
        Me.Rows("20:21").EntireRow.Hidden = Me.Range("E15").Value = ""
    End If
End Sub

Be aware though that change event will not trigger if cell values are changed by formula.

Dave

 

[Paul_11]

Works perfectly. Thankyou very much Dave!