Hi,
I am copying formulas in a table in the same column via VBA.
How do I prevent the formulas automatically being copied in ALL of the cells of the column?

Example:

Sub TestFormulas()
   Range("B2").formula = "=1+1" 
   Range("B3").formula = "=2+2"
   Range("B4").formula = "=3+3"
   Range("B5").formula = "=4+4"
End Sub
After running this in a sub all cells in column B of the table have the same formula "=4+4"
How do I prevent that ?