S
Schizoid Man
Hi,
I have a range of an array entered (Ctrl+Shift+Enter) formula that is
calculated using a function in VBA.
The value of each cell depends on inputs from other worksheets. I find
that if I change these inputs, the array entered cells will not
automatically recalculate (I have the options set to automatic
recalculation). In fact, even if I hit F9 or go to Tools > Options >
Calculation > Calc Sheet nothing happens.
The only way to recalculate the cells is to re-highlight the range and
hit Ctrl+Shift+Enter again.
I can rewrite the function slightly so that a regular enter will
suffice. However, given the computational complexity of the function,
and the size of the range, this is not a feasible solution.
Would appreciate any thoughts.
Schiz
I have a range of an array entered (Ctrl+Shift+Enter) formula that is
calculated using a function in VBA.
The value of each cell depends on inputs from other worksheets. I find
that if I change these inputs, the array entered cells will not
automatically recalculate (I have the options set to automatic
recalculation). In fact, even if I hit F9 or go to Tools > Options >
Calculation > Calc Sheet nothing happens.
The only way to recalculate the cells is to re-highlight the range and
hit Ctrl+Shift+Enter again.
I can rewrite the function slightly so that a regular enter will
suffice. However, given the computational complexity of the function,
and the size of the range, this is not a feasible solution.
Would appreciate any thoughts.
Schiz