hello all,
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
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