I have applied a name to a collection dispersed cells and want to use the
same as follows but require a correct piece of code for <<???:

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit:
If Target.Address <<IS A CELL OF THE RANGE NAMED "CELLS" Then
MsgBox "YES!"
End If
ws_exit:
Application.EnableEvents = True
End Sub

--
Thanx in advance,
Best Regards,

Faraz