Sub Traduction()
'IMPORTANT : cocher la référence "Microsoft Excel xx.x Object Library"
Dim MyXL As Excel.Application, cherche As String, r As Excel.Range
On Error Resume Next
Set MyXL = GetObject(, "Excel.Application")
If Err Then MsgBox "Excel absent...": Exit Sub
On Error GoTo 0
cherche = Trim(Replace(Selection.Range, Chr(13), ""))
Set r = MyXL.activeworkbook.sheets("Dictionnaire").[A1].currentregion
Set r = r.Find(cherche)
If r Is Nothing Then MsgBox "Mot introuvable...", , "Traduction": GoTo 1
Selection = r.Offset(, IIf(r.Column = 1, 1, -1))
1 Set MyXL = Nothing
Set r = Nothing
End Sub