Sub Multiplication()
[D25].Formula = "=K5*B$7"
[D25].Copy [D25:G31]
[D25:G31] = [D25:G31].Value 'supprime les formules
With [D25:G31].Borders
.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = xlAutomatic
End With
[D25:G31].Borders(xlInsideVertical).LineStyle = xlNone
[D25:G31].Borders(xlInsideHorizontal).LineStyle = xlNone
End Sub