Worksheet change event, ignore multiple cells

[ShaunM]

Hi All

I was hoping somebody may be able to answer what i beleive to a relatively simple question.

I am using the code below to ignore one cell in a worksheet change event, and it is working well. I would now like to expand it to ignore 2 cells ie. when anything other than cells C13 and F9 change a function is triggered.

The code I have is:

Private Sub Worksheet_Change(ByVal Target As Range)
    Set Target = Me.Range("C13") ' Ignore changes to cell c13
    
    If Intersect(Target, ActiveCell) Is Nothing Then
        Call adjust_Sheet
    End If
End Sub

many thanks is advance

[rylo]

Hi

How about

Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Address <> "$C$13" And Target.Address <> "$F$9" Then
    'call your sub
  End If
End Sub

rylo

[ShaunM]

Thanks Rylo,

Knew it was easy, after a long day I was trying to make it more complex than it needed to be.