Salut h2so4, iliess
essaye ces deux façons :
Sub Macro2()
Dim Arr, Tmps
Arr = Sheets("etatEncaissementNonIdentifier").Range("B1:L25669").Value
ReDim Tmps(UBound(Arr, 2) - 1, 0)
For i = LBound(Arr, 1) To UBound(Arr, 1)
If Arr(i, 1) <> "" Then
For j = LBound(Arr, 2) - 1 To UBound(Arr, 2) - 1
ReDim Preserve Tmps(UBound(Arr, 2) - 1, m)
Tmps(j, m) = Arr(i, j + 1)
Next j
m = m + 1
End If
Next i
Sheets("teste").Range("B1").Resize(UBound(Tmps, 2) + 1, UBound(Tmps, 1) + 1) = Application.Transpose(Tmps)
End Sub
Et :
Sub Macro3()
Dim Arr, Tmps
Set Etnsmt = Sheets("etatEncaissementNonIdentifier")
Arr = Etnsmt.Range("B1:L25669").Value
n = Application.CountIfs(Etnsmt.Range("B1:B9"), "<>" & "")
ReDim Tmps(n, UBound(Arr, 2) - 1)
For i = LBound(Arr, 1) To UBound(Arr, 1)
If Arr(i, 1) <> "" Then
For j = LBound(Arr, 2) - 1 To UBound(Arr, 2) - 1
Tmps(m, j) = Arr(i, j + 1)
Next j
m = m + 1
End If
Next i
Sheets("teste").Range("B1").Resize(UBound(Tmps, 1) + 1, UBound(Tmps, 2) + 1) = Tmps
End Sub