VBA code to run macro based on cells updated

[MartinBecks]

I found this code and changed it to what I need. But I know I left it only half way done. I want to run my macro called Request_Form but only if either cell J2 or T61 is changed. Cells J2 and T61 are dropdown menus. When I change those cells the macro runs correctly however, when I enter information and press enter in any other cell I get the following error.

Run-tine error '1004':
Method 'Range' of object'_Worksheet' failed

Please help me fix this code.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range


For Each cell In Target
If Not Intersect(cell, Range("J2,T61")) Is Nothing Then
Call Request_Form
ElseIf Not Intersect(cell, Range("")) Is Nothing Then

End If
Next cell

End Sub

 

[JoeMo]

See if removing this line fixes things:

ElseIf Not Intersect(cell, Range("")) Is Nothing Then

 

[JLGWhiz]

I found this code and changed it to what I need. But I know I left it only half way done. I want to run my macro called Request_Form but only if either cell J2 or T61 is changed. Cells J2 and T61 are dropdown menus. When I change those cells the macro runs correctly however, when I enter information and press enter in any other cell I get the following error.

Run-tine error '1004':
Method 'Range' of object'_Worksheet' failed

Please help me fix this code.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range


For Each cell In Target
If Not Intersect(cell, Range("J2,T61")) Is Nothing Then
Call Request_Form
ElseIf Not Intersect(cell, Range("")) Is Nothing Then

End If
Next cell

End Sub

JoeMo got it.

 

[MartinBecks]

Such a simple fix. Thank you. Works great.