On Mon, 2006-08-07 at 10:57 -0400, William Case wrote:
> 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.Have you looked at http://documentation.openoffice.org/project_list.html ? The codesnippet repository may have just what you are seeking. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/
smime.p7s
Description: S/MIME cryptographic signature
