Hi Andreas;
At the risk of starting a trip down memory lane, your email reminded me
of what it was that I was looking for. It no longer exists, I am sure.
On Mon, 2006-07-08 at 11:31 +0200, Andreas Saeger wrote:
> William Case wrote:
> > Thanks Klaas;
> >
> > But I vaguely remember (maybe from as far back as Lotus 1-2-3 days) I
> > could go to a new sheet or a clear spot on the current sheet and set up
> > something like:
> >
> > RANGENAME(bill, $C$3:$C45)
> > RANGENAME(frank, D$5:D$45)
> > RANGENAME(Klaas, $F$31:$G140)
> > ....
> >
> You remember the days when you could write macros on Lotus 1-2-3 sheets.
> I believe Excel can do that with an Excel5-compatibility-addin.
> How did you make a function RANGENAME()? Did you write a macro in
> StarBasic? Then your macro gets arrays of data from the arguments rather
> than a range-object.
>
Your right, it was a macro construction. It used braces {...} to set
off the macro functions, as I remember. There must have been a cell
addressing process or lookup command that pointed to the hand written
macro.
I suppose that if the range naming OO Calc gui was a macro I could find
what I wanted in the macros editor. But its not, so I am not going to
waste any more of my or your time pursuing the issue.
But Thanks again, Klaas and Andreas, for your quick response.
--
Regards Bill
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
