1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
| Public TABSSDB() As Variant
Public Sub atester(col)
Set mondico = CreateObject("Scripting.Dictionary")
Set mondico2 = CreateObject("Scripting.Dictionary")
Set wsess = Sheets("EMPLOIS")
For Each c In wsess.Range(wsess.Cells(2, col), wsess.Cells(200000, col).End(xlUp))
If Not mondico.Exists(c.Value) Then
mondico.Add c.Value, c.Value
End If
Next c
ReDim TABSSDB(mondico.Count)
For Each c In wsess.Range(wsess.Cells(2, col), wsess.Cells(200000, col).End(xlUp))
If Not mondico2.Exists(c.Value) Then
mondico2.Add c.Value, c.Value
TABSSDB(mondico2.Count) = c.Value
End If
Next c
End Sub
Public Sub atester_2(col_1 As Integer, col_2 As Integer)
Set mondico3 = CreateObject("Scripting.Dictionary")
Set mondico4 = CreateObject("Scripting.Dictionary")
Set wsess = Sheets("EMPLOIS")
For Each c In wsess.Range(wsess.Cells(2, col_1), wsess.Cells(200000, col_1).End(xlUp))
If Not mondico3.Exists(c.Value) Then
mondico3.Add c.Value, c.Value
End If
Next c
ReDim TABSSDB(mondico3.Count)
For Each c In wsess.Range(wsess.Cells(2, col_1), wsess.Cells(200000, col_1).End(xlUp))
If Not mondico4.Exists(c.Value) Then
mondico4.Add c.Value, c.Value
TABSSDB(mondico4.Count) = c.Value
End If
Next c
End Sub |
Partager