Hi,

How can I assign a cell's value equal to another cell
using a macro. I would like to address the cell by it's
own cell box name that I will assign. For example:

Cell Box Cell Name
A1 JanBalBF
A10 JanBalCF
C1 FebBalBF
C10 FebBalCF

Now, I want to use the macro to assign the value in A10
to C1 by addressing the cells by using the Cell Name
assigned earlier. I tried using the following formula in
the macro, unfortunately doesn't work

LET [FebBalBF] = [JanBalCF]

I got the error #NAME in the C1 Cell.

How can I go about doing it?

Thanks in advance.