target.address query

[BigDelGooner]

Afternoon all

I have the following code...

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$316" Then
Chart_DownMonths
End If
If Target.Address = "$C$318" Then
Chart_DownMonths
End If

End Sub

...but wanted to know who I can change the absolute reference (i.e. $C$316) to a named range.

Any ideas?

 

[Jonmo1]

Try

If Target.Address = Range("NamedRange").Address Then

 

[BigDelGooner]

Perfect...and also a solution I should have thought of myself.

I was trying address(range" etc...

Thank you very much.