VB Code:
  1. Cells(i, 9).Value = "=SUM(R[K+1]9:R[i-1]9)"

i want to make a code line that actually selects a number of cells in excel and add them up .the selection is done as from (k+1) to (i-1) and result is return in cell(i,9).
actually there is a loop going on in the program to perform a number of additions .