Hello
anyone can tell where I went wrong with this code ? I am trying to SUM($D$1:D15) but it is doing SUM($D$1:E15)
ThanksRange("F15").Select ActiveCell.FormulaR1C1 = "=IF(LEN(RC[-1]>0),SUM(R1C4:RC[-1]),"" "")"
Hello
anyone can tell where I went wrong with this code ? I am trying to SUM($D$1:D15) but it is doing SUM($D$1:E15)
ThanksRange("F15").Select ActiveCell.FormulaR1C1 = "=IF(LEN(RC[-1]>0),SUM(R1C4:RC[-1]),"" "")"
RC[-1] says stay in the same row, but move one column to the left. Since the formula is being written to column F, it results in column E.
Ben Van Johnson
RC[-3] and it worked !
Thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks