>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

oExcel.Cells(rows,Cols+5).Formula = "=SUM(F8:F&rows)"    

MartinaJ