Temporary Variables/Let?
Posted by Eric Snow on May 29, 2001 10:00 AM
Is there anyway to assign a value to a temporary variable in a function, so an entire expression doesn't have to be used over and over? For instance, in scheme you can:
(define ...
(let ((var1 (some expression)))
...other stuff...))
or in C,
int var1=(some expression);
...other stuff...
I imagine this could be done in VBA, but is there any way to get it into just one of the cell formulae?
Thanks
-Eric Snow (who finds working with data structures in his own programs easier, at least until he can figure these things out.)