Hi,
this from a complete Excel VBA novice....
The above code snippet works fine, using the hardcoded column numbers 1 and 9.For i = 1 To 10 Cells(i, 14) = "=sum(RC[-1]:RC[-9])" Next i
Question: The range of the "sum" function varies in my application, how would I use a variable instead of the hardcoded 1 and 9 ?
e.g.
which obviously gives me an error ?Cells(i, 14) = "=sum(RC[-x]:RC[-y])"
Bookmarks