* Ennio-Sr <[EMAIL PROTECTED]> [090305, 19:13]:
> * Eike Rathke <[EMAIL PROTECTED]> [090305, 15:17]:
> > Hi Ennio-Sr,
> >
> > On Tue, Mar 08, 2005 at 01:38:06 +0100, Ennio-Sr wrote:
> >
> >
> > If you don't want references of named ranges be adapted according to
> > deletions and insertions, use relative addressing instead of absolute.
> > For example, define a named range as $Sheet2.A1:B4 instead of
> > $Sheet2.$A$1:$B$4
>
> It would be great if one could use range names, instead; I mean not only
> in the same sheet but in another doc or sheet as well. [That is possible
> in Lotus Millennium].
> >
Eike!
sadly enough, I must update my last sentence to:
"It would be great if references (either to cell ranges or to cell names
worked at all ......;("
I've just found out that the named ranges I defined in the table
resulting from the Insert > External Data are useless: when I refer to
them, even in the same sheet ("=Quote.rn_x" or "=Quote.Bx") I get "0"
whatever value is in the referee cell.
It seems to me that what appears to be the imported table is a sort of
'floating single compact stuff' on top of a void sheet; this accepts
cell name ranges but, of course, evaluates them to 0 because the numbers
apparently in the cell belong to the 'floating stuff'.
Is there any way to do what I'm attempting to do? Shall I do it in a two
stage procedure: first save the web site table as a .txt file and then
import it in the sheet?
Thanks,
Ennio.
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (�|�)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
