Hi Sandy,

perhaps you can use a for each... next loop to loop through each series,
select it, and then run the xlm macro on each of the series?

Beyond that, I don't think I can help you, perhaps one of the real gurus out
there can.


"Sandy V" wrote in message
...
Hi Mike,

Thanks for replying. Unfortunately the series name is not
what I need.

Sname = ExecuteExcel4Macro("SELECTION()")
This XLM would return "S1" if the first original and
entire series is selected.



Typically "S1" would refer to Series(1) but not
necessarily, an observation pointed out by Jon Peltier.
I could work with series names if they were guaranteed
unique, but they are not.

To side-track, the same macro is suggested to advise users
of the selected series & point (eg "S1S4"). Whilst it
returns the correct point, the returned series index might
not be correct.

I still think a static object identifier (if that's the
right term) must exist for each series. I have
studied "Macrofun.hlp" re this and other XLM's for clues
but to no avail (a quick search finds MS's download link
for this help file).

The XLM gets what I want but only if selected.
But how does it get that identifier!

With regards,
Sandy

PS I've been monitoring but only just seen your reply
today (25th) although it's dated the 22nd, odd. I
received a "friendly notification" of it from "Developers
Dex", as I have sometimes in the past, first time one has
been useful!