1 2 3 4 5 6 7 8 9 10 11 12
| Sub ChercheColonne()
Dim rng As Range, NumCol As Integer, LookedRange As Range, LookedField As String
LookedField = "Date" ' Champ recherché
Set rng = ThisWorkbook.Worksheets("db").Range("A1").CurrentRegion
On Error Resume Next
NumCol = Application.Match(LookedField, rng.Resize(1), 0)
If Err Then MsgBox "Le champ " & LookedField & " n'existe pas": On Error GoTo 0: Exit Sub
With rng ' Affectation de l'adresse de la colonne contenant le champ cherché
Set LookedRange = .Offset(1, NumCol - 1).Resize(.Rows.Count - 1, 1)
End With
MsgBox "La plage complète de la colonne " & LookedRange.Address
End Sub |
Partager