0

Good day!

I just want a little help on how to loop from one cell to the end and set a sum Formula. I have Columns From **F to O **and created a Sum formula for column F. Is there a way to make it in a loop and pass only the column name in the Sum Formula to sum up until column O?

My code below to sumup only Column F. I basically need a loop here to sum up up to the column O.

```
excel_worksheet.Range("F" & (FormulaRow + 1)).Value = "=SUM(F" & FormulaStartRow & ":F" & FormulaRow & ")"
excel_worksheet.Range("F" & (FormulaRow + 1)).RowHeight = 25.5
excel_worksheet.Range("F" & (FormulaRow + 1)).Font.Bold = True
```

Thanks for helping!