Sub Transfere()
Dim TSrc(), LSrc&, TCbl(), LCbl&, C&
TSrc = Intersect(Feuil1.Rows(4).Resize(1000000), Feuil1.UsedRange).Value
ReDim TCbl(1 To UBound(TSrc, 1), 1 To 6)
For LSrc = 1 To UBound(TSrc, 1)
If VarType(TSrc(LSrc, 8)) <> vbDate Then
LCbl = LCbl + 1
For C = 1 To 6: TCbl(LCbl, C) = TSrc(LSrc, C + 1): Next C: End If: Next LSrc
Feuil2.[A4].Resize(1000000).ClearContents
Feuil2.[A4].Resize(LCbl, 6).Value = TCbl
End Sub
Sub Transfere()
Dim TSrc(), LSrc&, TCbl(), LCbl&, C&
TSrc = Intersect(Feuil1.Rows(4).Resize(1000000), Feuil1.UsedRange).Value
ReDim TCbl(1 To UBound(TSrc, 1), 1 To 6)
For LSrc = 1 To UBound(TSrc, 1)
If VarType(TSrc(LSrc, 8)) <> vbDate Then
LCbl = LCbl + 1
For C = 1 To 6: TCbl(LCbl, C) = TSrc(LSrc, C + 1): Next C: End If: Next LSrc
Feuil2.Rows(4).Resize(1000000).ClearContents
Feuil2.[A4].Resize(LCbl, 6).Value = TCbl
End Sub