Thread: Variable in a VBA macro

Hello to all!
I mexcuse in advance if this subject already exists (as nouvo this forum .....).

Here is my concern.
I sui Newb prog in VBA and I n'arive not implemented a code marcro my VBA code.
Here is my snippet:

place = 5
LINE = 2

Do Until Sheets ( "DB"). Cells (LINE, 1) = ""
Sheets ( "tb_de_calcul"). Cells (7, up) = Sheets ( "DB"). Cells (LINE 2) & "" & Sheets ( "DB"). Cells (LINE 3)

Cells (30, up) = "= AVERAGE (& Cells (11, place): Cells (22, place))"
LINE = LINE + 1
place = place + 1
Loop

My problem is on the line
Cells (30, up) = "= AVERAGE (& Cells (11, place): Cells (22, place))"

I would make the average of several cells for each column but can not integrate my variable place .......

I guess I go for a v naz save me but its good life if you help me.

Thank you in advance

When programming in Visual Basic, we use only rarely forms (the "=....") in cells.

This can be done, however, for example to the average Celulle A1 to A5 in cell A6:

Code:

Range ( "A6"). Formula = "= AVERAGE (A1: A5)" 
Range ( "A6"). Calculate

See also FormulaR1C1, etc..

Thank you for your answer but what I would use my variable is "up" to vary my columns.
Is this possible?

Yes, it is possible FormulaR1C1, and good use of quotes and &.

I am very thankful to you.