Bonjour,
Ci-dessous code modifié avec annotations.
Cdlt.
Option Explicit
Public Sub DEMO()
Dim ws As Worksheet, ws2 As Worksheet
Dim tbl As Variant
Dim dict As Object
Dim numCol As Long, I As Long
Dim x As String
Application.ScreenUpdating = False
Set ws = Sheets("match")
Set ws2 = Worksheets("accueil")
numCol = 3 'numero de colonne de référence
ws2.Cells(6, 1).CurrentRegion.Offset(1, 0).ClearContents
tbl = ws.Cells(1).CurrentRegion.Value
Set dict = CreateObject("Scripting.Dictionary")
For I = 2 To UBound(tbl, 1)
x = Split(tbl(I,numCol))(1)
dict(x) = ""
Next I
ws2.Cells(7, 1).Resize(dict.Count, 1) = Application.Transpose(dict.keys)
Set dict = Nothing
Erase tbl
Set ws2 = Nothing: Set ws = Nothing
'Complément
Call CreaOngl
End Sub