Increasing a variable by one without using a function

I have the following problem with excel. I want to increase a variable by one without using a function. So i mean without writing a "=" before my expression. Example:

B1.c_O2_L_y.Value(i)

B1.c_O2_L_y.Value(1)

B1.c_O2_L_y.Value(2)

B1.c_O2_L_y.Value(3)

B1.c_O2_L_y.Value(4)

B1.c_O2_L_y.Value(5)

B1.c_O2_L_y.Value(6)

B1.c_O2_L_y.Value(7)

B1.c_O2_L_y.Value(8)

开发者_如何学JAVAB1.c_O2_L_y.Value(9)

B1.c_O2_L_y.Value(10)

B1.c_O2_L_y.Value(11)

B1.c_O2_L_y.Value(12)

.......

I must do that for many expressions and for i > 500. So i can't do that by hand. I would be thankful for any advice.

---

Do it with a function, then "copy" and select "paste as...". In the sub menu select the radiobutton in front of "values". Your formulas are now overwritten by the actual values.

---

Maybe your function is wrong. Try something like

=CONCATENATE("B1.c_O2_L_y.Value(",ROW(),")")