Formula not evaluating immediately
Excel uses arguments (cell references) to functions and formulas to establish the order of recalculation (the dependency tree).
The literal in the INDIRECT function call is not recognized as a cell reference, so the order of calculation may be incorrect. If
it is evaluated after other cells which influence your result, it may show the correct value only at the next recalculation.
I'm not sure what you mean by "procedure" in this case.
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Barb Reinhardt" wrote in message
...
|I have the following formula in my procedu
|
| =IF(ISNUMBER(SEARCH(Z$1,FORMULATEXT(INDIRECT("'["&$G3&"]Summary
| (A)'!$I$11",TRUE)),1)),"YES","NO")
|
| G3 is a workbook name like Workbook.xls. When the procedure executes, the
| result is displayed as "NO" in the sheet. If I then go back and press ENTER
| on the field, it changes to YES. The procedure has a CALCULATE statement in
| it just in case I've got manual calculation set on my system. I actually
| have it set to automatic right now. I have a similar formula in other cells
| that works without a problem. I'm not sure what the problem is.
|
| Can someone assist?
|
| Thanks
|