i need help with summing rows and columns of various lengths using VBA. my code puts the cursor on say cell D10. in this cell i want the formula for summing the row DX to D9. the x is variable and is stored in SUMCOLSTART.

i don't want the result in cell D10. i want the formula (for example =SUM(Dx:D9)) in the cell so that i can copy it down several rows.

i've been playing with several pieces of code but all put the number in D10, not the formula

thanks,

lpsd