At 08:38 18/03/2008 +0100, Cor Nouws wrote:
I've a formula in a range of cells, that can evaluate to a value,
but also can evaluate to nothing.
Example: =IF(AND(A13>5;A14>5);A13;"")
Now using the keys ctrl-arrow to navigate, the cursor jumps to the
first/last cell in that range.
Example of cells with formula:
all have the same formula> A2 A3 A4 A5 A6 A7
value as result in the cell> 5 5 7
(I trust it's not *exactly* the same formula, as that would normally
be expected to produce identical results! Er, yes: I'm aware of the
exceptions to this.)
You have confused the matter a little here, as you have laid out your
description horizontally and then talked of using the left arrow key
- which might be appropriate for a row - but you label your cells as
A2 to A7, which are actually elements of a column rather than a
row. And then you later say "left" when I suspect that you must mean
"right". (Apologies if I've misunderstood this.) Assuming that you
are describing a row and that you do mean "right" ...
When in A1 and pressing Ctrl-[right], the cursor goes to A2.
pressing Ctrl-[right] again, the cursor goes to A7.
I would have liked if the cursor jumps to a cell that holds a value.
So, when in A1 and pressing Ctrl-[right], that the cursor goes to
A3. pressing Ctrl-[right] again, that the cursor goes to A4.
Is this behaviour by design, or that can't be avoided, or that can
be changed via an option, or ...
I can't say whether it is by design, but it is certainly what
happens. The help text talks of "data ranges" and contrasts them
with cells that are "empty". Clearly a cell that contains a formula
which happens to evaluate to a null string is not regarded as
"empty", but instead as holding a value (as you put it) - the formula
itself. I don't know of any way in which this can be configured.
Depending on what you are trying to achieve, one workaround could be
to copy the data area and use Paste Special with Numbers ticked and
Formulas not ticked, either back in place or somewhere else. You
could then navigate around in your row more as you wish. But note
that, even then, this technique does not move to the next cell that
contains a value but rather to the last cell in the current data
range. Ctrl+right in your A3 will move to A4 not because it is the
next occupied cell, but because it happens also to be the last cell
in the present contiguous range of occupied cells. If A5 were
occupied, focus would move there (or beyond).
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
