Run macro with multiple numeric values

[ENTERTAIN]

I want run a macro when one of several pre determined numbers appear in a given cell.
When compiling the code how do I separate the list of different numbers?
I thought comas would work but they don't.
Could someone please advise?

 

[jasonb75]

I thought comas would work but they don't.

It would work if you use Select Case, but will not work with If.

 

[dmt32]

You could place values in an array & check against that

example

If Target.Address = "$D$10" Then
        m = Application.Match(Target.Value, Array(1, 10, 24, 32), 0)
        If Not IsError(m) Then Call mymacro
    End If

Dave