Everything between " and " is treated as a string. Try something like

Cells((OneWkRow + 8), Counter).Value = _
"=Sum(" & c1_right_1 &":" & c_right_1 & ")"

HTH
Rowan

"KyWilde" wrote:

I would like to put this formula into a specific cell. Here is my code:
for Counter 1 to 20
Cells((OneWkRow + 8), Counter).Value = "=Sum(c1_right_1 : c_right_1)"
Next Counter

Why is this not working? Can I not use variables in this instance? How can
I make this work? Thanks!!!