hobgoblinvasya
Board Regular
- Joined
- Jun 29, 2005
- Messages
- 215
hey everyone, my question is pretty straightforward:
is there a way for a udf to return the cell's original value instead of an error.
ie. the UDF in the cell returned a value from a database. now if i move the database and reopen this sheet, excel will try to recalculate and if it doesn't find the database it will return an error. instead of that i just want excel to return whatever was in the cell, before it had to be recalculated.
is there any way to achieve this behaviour?
tnx in advance
is there a way for a udf to return the cell's original value instead of an error.
ie. the UDF in the cell returned a value from a database. now if i move the database and reopen this sheet, excel will try to recalculate and if it doesn't find the database it will return an error. instead of that i just want excel to return whatever was in the cell, before it had to be recalculated.
is there any way to achieve this behaviour?
tnx in advance