Ive tried the automation as you suggested, and it works, but i cant figure out how to put the formula as value using the variables in setting the range of cells

rows=8
cols=1

rows=rows+2

oExcel.Cells(rows,Cols+5).Value = "=SUM(F8:F&rows)" && this doesnt work, it doesnt turn into =sum(F8:F10) having problem with setting the range of cell

any suggestions please

thanks