novice_2010
Board Regular
- Joined
- Mar 18, 2010
- Messages
- 105
Hello, All
I am trying to understand how circular references is working.
Here is an example:
I ends up getting:
cells(1,1) = 1
cells(1,2) = 0
of which the correct result should be cells(1,1) = 2, cells(1,2) = 1
What did I do wrong?
I am trying to understand how circular references is working.
Here is an example:
Cells(1,1).formula = "= B1 + 1"
Cells(1,2).formula = "= A1 / 2"
I ends up getting:
cells(1,1) = 1
cells(1,2) = 0
of which the correct result should be cells(1,1) = 2, cells(1,2) = 1
What did I do wrong?