* Andrew Douglas Pitonyak <[EMAIL PROTECTED]> [090305, 00:50]:
>
>
> Ennio-Sr wrote:
>
> >* G. Roderick Singleton <[EMAIL PROTECTED]> [080305, 12:43]:
> >
> >
> >>On Tue, 2005-03-08 at 19:29 +0100, Ennio-Sr wrote:
> >>
> >>
> >>>* Andrew Douglas Pitonyak <[EMAIL PROTECTED]> [070305, 22:13]:
> >>>
[....]
> >However, having found the Math help and read whatever could be related
> >to my problem (i.e. how to reference a 'named-range cell' in another
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> >doc/sheet via an equation) I couldn't find a solution. Would Andrew be
^^^^^^^^^
> >so kind to post an example?
> >Thanks for your attention. Regards,
> > Ennio.
> >
> >
> Do you want a posting of how to use a named range, or how to use this in
> a macro? Here is a description that I created of named ranges, or at
> least a little snippet of text. Now, all of these things assume that I
> am using the named range in the document in which it is defined. I do
^^^^
> not think that I can reference a named range in a completely different
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> document. I mean, I can look at the named ranges and how they are
^^^^^^^^
> defined, but I do not think that I can use an external named range in a
> different sheet in part of an equation.
> [....]
Hi, Andrew,
Unluckily, that's exactly what I was looking for :-)
Your previous answer gave me the impression I could achieve it
using an equation: that's why I asked you to explain how. I'm
sorry to have wasted your time.
Shall I conclude there is no straight way to do it ? I know I can set up
a macro which can use an external named range in a different sheet:
this, however, will result in a very long set of instructions when the
named ranges involved are, say, around 50. I have this cross reference
in a lotus.123 file and it takes 50 rows only: had I to substitute it
with a macro, it would probably take from 500 to 1000 rows.
This rough calculation is based on a sample macro I got using the macro
recorder: may be it could be refined but not reduced to a single line...
Thanks for your time.
Regards,
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]
