[COLOR="DarkSlateGray"]Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim selection As String
If Not Application.Intersect(Target, Union([Sigma1], [Sigma2], [Sigma3], [Sigma4], [Sigma5], [Sigma6])) Is Nothing Then
Application.ScreenUpdating = False
selection = "Sigma" & UniquementChiffres(Target[B][COLOR="Red"].Cells(1, 1)[/COLOR][/B].Name.Name)
[Resultat].Value = selection
End If
Cancel = True
Application.ScreenUpdating = True
End Sub[/COLOR]