This is a long term problem that I have with Excel.
I mostly write worksheet applications that have plenty of
user-configurable parameters up front. This is fine for interactive
work and what-if scenarios.
However many of these turn into situations where I then want to scan
through parameters where it would be nice to insert new values into
the parameter cells under program control (either via a worksheet
cell, or using a macro).
There are far simpler cases over and above this that could benefit
from this too.
So is there an implementation of
[G15] = Assign( H15, A15) // H15 = Content of A15 ?
The point being that I don't want
[A15] = H15
for reasons that several donor cells could write into A15 (I know this
raises the issue of precedence, but there could be a simple resolution
for this based on donor cell position).