Hi,
I have this code and I got "Error 424 Object Required". Any idea on the cause? Here's the code:
Any help would be appreciated!
I have this code and I got "Error 424 Object Required". Any idea on the cause? Here's the code:
VBA Code:
Sub AC_idle()
Dim Res As Variant
If Target.CountLarge > 1 Then Exit Sub
If Not Intersect(Target, Range("N18, Q15:Q28")) Is Nothing Then
Res = Evaluate("INDEX(N18,MATCH(" & Target.Address & ",J18,0))")
If Not IsError(Res) Then Target.Offset(, 1) = Res
End If
End Sub
Any help would be appreciated!