Envoyé par
boisgontierjacques
Bonjour,
1 2 3 4 5 6 7 8 9 10 11 12 13 14
|
Sub essai()
Dim nrow As Integer
Dim ncol As Integer
nrow = InputBox("Type number of rows")
ncol = InputBox("Type number of columns")
Dim ArrayVariable(): ReDim ArrayVariable(1 To nrow, 1 To ncol)
For i = 1 To UBound(ArrayVariable)
For j = 1 To UBound(ArrayVariable, 2)
ArrayVariable(i, j) = Rnd()
Next j
Next i
[A1].Resize(UBound(ArrayVariable), UBound(ArrayVariable, 2)) = ArrayVariable
End Sub |
Boisgontier
Merci beaucoup, pourrais tu m'expliquer ce que veut dire
[A1].Resize(UBound(ArrayVariable), UBound(ArrayVariable, 2)) = ArrayVariable
Et aussi UBound?
Merci pour l'aide
Partager