"joeu2004" wrote in message
...
On May 12, 12:40 pm, "Cimjet" wrote:
[ ]
However, you still need to answer a critical question: when is it
necessary to recompute I50:I53? Only when a cell changes in the
ranges $B$6:$AF$17, $B$21:$AF$32 and $B$36:$AF$47?


"Cimjet" wrote in message
...
Hi Clif
Let me try to answer those questions.
[ ]
If you want to limit the SheetChange computation based on Target,
you
need to provide more information, namely: when do you want to
perform
the computation? That is, when which cells (ranges) are edited?
I am guessing only when $B$6:$AF$17, $B$21:$AF$32 and $B$36:$AF$47
are
edited. Right?


The answer is "Yes



--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)