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 40 41 42 43 44 45 46 47 48 49 50 51
| Sub test()
Dim arrayA() 'dynamique
' Méthode 1
arrayA = Range("A1:A3") ' Explicitement : arrayA(1 To 3, 1 To 1)
[J1] = "arrayA(" & LBound(arrayA, 1) & " To " & UBound(arrayA, 1) _
& ", " & LBound(arrayA, 2) & " To " & UBound(arrayA, 2) & ")" ' Littéralement : arrayA(1 To 3, 1 To 1)
[J:J].Columns.AutoFit
' Méthode 2
arrayA = Range("A1:C1") ' Explicitement : arrayA(1 To 1, 1 To 3)
[K1] = "arrayA(" & LBound(arrayA, 1) & " To " & UBound(arrayA, 1) _
& ", " & LBound(arrayA, 2) & " To " & UBound(arrayA, 2) & ")" ' Littéralement : arrayA(1 To 1, 1 To 3)
[K:K].Columns.AutoFit
' Méthode 3
arrayA = Range("A1:C3") ' Explicitement : arrayA(1 To 3, 1 To 3)
[L1] = "arrayA(" & LBound(arrayA, 1) & " To " & UBound(arrayA, 1) _
& ", " & LBound(arrayA, 2) & " To " & UBound(arrayA, 2) & ")" ' Littéralement : arrayA(1 To 3, 1 To 3)
[L:L].Columns.AutoFit
' Méthode 4
arrayA = Array("11", "22", "33") ' Explicitement : arrayA(0 To 2)
On Error GoTo RE1
aa = LBound(arrayA, 1) & " To " & UBound(arrayA, 1)
RE1: If Err.Number = 9 Then aa = "0 To 0"
Resume Next
'--------------
On Error GoTo RE2
bb = LBound(arrayA, 2) & " To " & UBound(arrayA, 2)
RE2: If Err.Number = 9 Then bb = "0 To 0"
Resume Next
'---------------
[M1] = "arrayA(" & aa & ", " & bb & ")"
[M:M].Columns.AutoFit
' Méthode 5
ReDim arrayA(1 To 2, 1 To 2, 1 To 2)
arrayA = Worksheets(2).Range("A1:A2")
[G10] = "arrayA(" & LBound(arrayA, 1) & " To " & UBound(arrayA, 1) _
& ", " & LBound(arrayA, 2) & " To " & UBound(arrayA, 2) _
& ", " & LBound(arrayA, 3) & " To " & UBound(arrayA, 3) & ")" '
[G:G].Columns.AutoFit
End Sub |
Partager