I have A1 = 5 and I've added A1 as a name "Protagonist".
If i do =Protagonist
its going to come up with 5.
Say in D12 I want to do =Protagonist+1
Its going to come up with 6.
- What i want achieve is replace the "protagonist" with the 5
and have the D12 formula remain
=5+1
.
I need to do this as A1 constantly changes its value and I only need to keep the value it has at the time of making a formula that uses it.
(Manually i know i can select Protagonist and hit F9 to resolve only that part of the formula, but thats a major time consumption in the amounts i have to do it)
This can happen after the formula is entered and resolved. Though it would be so amazing if it could happen in the formula bar while typing, but I would guess vba doesn't stretch that far.
=A1 + 1
or=5 + 1
or=6
or6
??