Change target address to range name

[Legacy 102432]

Hi, I have a few worksheet change events like the below, but I want to change the "If Target.Address(0,0) = "L17"" so that L17 refers to the "Office" range instead. What words do I need to replace to make this work?

Thanks in advance

Private Sub Worksheet_Change(ByVal Target As Range)
'The code below enables macros to unhide the next section of the form after someone has made the final selection'
'from a dropdown list in that section.
 
'L17 is the "Office" dropdown box in the Requestor Details section
If Target.Address(0, 0) = "L17" Then
    If Target.Value = Range("PleaseSelectCell").Value Then
        Call HideAllForm
    Else
        Call UnhideMoveType
    End If
End If
 
End Sub

 

[Andrew Poulsom]

Is it?

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

 

[Legacy 102432]

Thanks for the quick response Andrew. That works perfect!