Bottom posted.
<<BIG SNIP>>
Terry,
Thanks for the explanation, and yes, it looks logical. I agree that a formula
like NOW() may not, after having been entered into a cell, change values
dynamically (could be potentially disastrous).
On the other hand, let me see if I can apply this logic to my problem, and see
if I get this right :
When I have a cell with "=cell("filename";B1) in cell A1, it returns the
**current** name of the sheet to me. Perfect, logical.
I change the name of the sheet, and **then** enter, into cell A2 (not A1), the
same formula. I expect to get the **current** name of the sheet, right ?
Well, I do not. This is my, ah, grouse (no offense meant).
I certainly agree that there could be issues to dynamically change the value
returned by the function call made at an earlier point in time. What then,
prevents the later invocation of the same function, at a *different*
location, to return the **current** value ?
By the way, and not trying to nit-pick (or split hairs) I wanted to see what
happens with the "NOW" function.
In A1, entered =NOW(). Got a date/time combination.
In A2, after around a minute, entered =NOW(). Got the current date/time,
which is around a minute more than the previous invocation. However a
surprise - the value in A1 *also changed*, to reflect current date time.
Probably an aberration ?
With due apologies for any inaccuracies in the description of the problem, or
in my response to you.
Not too surprising, since you want the spreadsheet recalculated each
time you modify it.
Joe
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
