Sub EnTeteColonne()
Dim x$, c As Range
x = InputBox("Valeur cherchée :")
If x = "" Then Exit Sub
With [A1].CurrentRegion 'tableau à adapter
Set c = .Find(x, , xlValues, xlWhole)
If c Is Nothing Then MsgBox x & " pas trouvé..." Else _
MsgBox "En-tête : " & Intersect(.Rows(1), c.EntireColumn)
End With
End Sub