Option Explicit
' Déclaration variable
Dim formule1, formule2 As String
Sub test()
' la macro
' en cas d erreur
On Error GoTo plouf
' la feuille1
With Sheets("feuil1")
Range("d15").Select
formule1 = "=2"
ActiveCell.FormulaR1C1 = formule1
Range("h15").Select
formule2 = "=2"
ActiveCell.FormulaR1C1 = formule2
End With
' la selection
Range("d15:h15").Select
plouf: Exit Sub
End Sub