What I want is a cell function like ADDRESS(), but instead of a reference
to a single cell, I want a reference to a cell range.
ADDRESS(1;1;1) ⇨ $A$1
ADDRESS(2;2;4) ⇨ B2
I would like something like this:
RANGEADDRESS(1;1;1;2;2;4) ⇨ $A$1:B2
Can't find such a function, though. What do I miss?
Can I use ADDRESS() in some combination to obtain this anyway?
Here is a quick example of what I'd like to do:
=SUM(RANGEADDRESS(A1;B1;C1;D1;E1;F1))
--
Kind regards
Johnny Rosenberg
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org