Question

make an assignment on cell referencing​

Answer 1

Explanation:

I am trying to assign a formula to a cell whose reference changes at every iteration. The left-hand side of the assignment below, however, seems to work since if I make the right-hand side "=""Test""", it seems to work.

I guess the problem then is with my formula on the right hand side. There is a combination of strings, a variable that changes with each loop iteration and a value taken from a cell.

Good evening

XD

Answer 2

$\huge\mathbb\fcolorbox{purple}{lavenderblush}{✰Answer}$

A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet.

• For example, A1 refers to the cell at the intersection of column A and row 1; B2 refers to the second cell in column B, and so on.

• For example, the range A1:C2 includes 6 cells from A1 through C2.