William Case wrote:
Thanks Klaas;
On Mon, 2006-07-08 at 13:20 +1000, Klaas Visser wrote:
The easiest method is to highlight the range of cells you want to name
(click and drag), and then go to the Name Box on the tool bar (left hand
corner) which will be showing the range you have selected (eg, C3:E45), and
type in the desired name.
This is the same functionality as MS Excel, if you've used that in the past.
This is what I am currently doing.
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)
....
Function name RANGENAME() is made up. If I could remember what it was I
would look for something like that. But as you can see, if one has a
long list of complex range names that sometimes overlap, are subject to
relative and absolute cell values, etc. having them all laid out in
front of one, would make things simpler to double check and to change
and adjust.
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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
