Okay, I can see where you are coming from. I'm fairly new to OpenOffice, but have reasonable exposure in Excel (mostly v2002 and v2003). I've always found the MS Excel (and now OpenOffice) method and interface fairly straight forward, even with 3D ranges and the like.
I don't recall any function that effectively provides you with a tabular form of the current defined ranges, but that doesn't mean it doesn't exist. I imagine that creating a custom function via a macro would be possible, but don't know how to go about it. Klaas ----Original Message----- From: William Case [mailto:[EMAIL PROTECTED] Sent: Monday, 7 August 2006 14:42 To: [EMAIL PROTECTED] Cc: [email protected] Subject: RE: [users] Function for naming ranges ?? 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. -- Regards Bill --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
