Sub Macro1()
Dim chiffres
chiffres = Array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10)
[B1:K1] = chiffres
[A2:A11] = Application.Transpose(chiffres)
[B2:K11] = "=(ROW()-1)*(COLUMN()-1)"
With Range("A2:A11,B1:K1")
.Font.Bold = True
.Interior.ColorIndex = 6
End With
[A1].CurrentRegion.Borders.LineStyle = 1
[A1].CurrentRegion.Columns.AutoFit
End Sub