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(),")")