Hello,
Pas directement, voici une proposition :
Sheets("Bilan").Select
Dim strAdress As String
For Each C In Range("h3", "h110")
If Left(C.Value, 1) = "A" Then strAdress = strAdress & C.Address & ","
Next C
strAdress = Left(strAdress, Len(strAdress) - 1)
Range(strAdress).Select
Selection.Copy
Sheets("AV").Select
Range("B2").Select
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveSheet.Range("$B$2:$B$110").RemoveDuplicates Columns:=1, Header:=xlNo
Range("A1").Select