Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
'Macro par Dan pour Eric
'http://www.excel-downloads.com/forums/2-128627-recherche-une-cellule-vide.htm
Dim col As Variant
Dim plage as Range
Set Plage = Range('B10:K500')
col = ActiveCell.Column
If Not Application.Intersect(Target, Plage) Is Nothing Then
ActiveCell = Cells(1, col).Value
End If
End Sub