Todor
As you do not appear to be subscribed you might have missed these
replies to you question
Niklas Nebel wrote:
Dennis Marks wrote:
I don't think that you can combine an actual cell reference with a
formula generated cell reference. I tried to do it with a search for
a second match and was unsuccessful. I ended up using another method.
(See perpetual calendar messages)
If there is a way to do it I would like to know the answer too.
$C$2:INDIRECT...
INDIRECT("C2:"& ...)
Or, if you want a real cell reference that's updated when cells are
moved, and don't mind an ugly formula,
INDIRECT(ADDRESS(ROW($C$2);COLUMN($C$2))&":"& ...) or
INDIRECT(CELL("ADDRESS";$C$2)&":"& ...)
Have you ever succeeded to use this method in another formula?
The general mechanism is in fact missing, see issue 4904.
Niklas
--
OOo 2.0.1 & OOo 2.0-dev; SeaMonkey 1.0; Win XP sp2
==============================================
http://www.answersingenesis.org/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
