Sub RechercheNom()
Dim nom As Name, dat As String
For Each nom In ThisWorkbook.Names
If nom.RefersTo = "=" & ActiveSheet.Name & "!$D:$D" Then
MsgBox "Nom de la colonne D : " & nom.Name
'dat = Right(nom.Name, 8) 'éventuellement...
'MsgBox dat
End If
Next
End Sub