Option Explicit
Sub Tableau200200()
With Feuil1.[C1].Resize(200, 200)
.FormulaR1C1 = "=OFFSET(R1C1,(COLUMN()-3)*200+ROW()-1,0)"
.Value = .Value: End With
End Sub
Option Explicit
Sub Tableau200200()
With Feuil1.[C1].Resize(200, 200)
.FormulaR1C1 = "=OFFSET(R1C1,(COLUMN()-3)*200+ROW()-1,0)"
.Value = .Value: End With
End Sub
Bonsoir.
VB:Option Explicit Sub Tableau200200() With Feuil1.[C1].Resize(200, 200) .FormulaR1C1 = "=OFFSET(R1C1,(COLUMN()-3)*200+ROW()-1,0)" .Value = .Value: End With End Sub