Saxman wrote:

I do get <blank series, as most events have differing numbers.

I have a piece of code that copies/pastes the names in the series and places them
in the 'Archive' worksheet. These are then placed at the foot of the graph in a
legend for reference.

I do get <blank series, as most events have differing numbers.

I have a piece of code that copies/pastes the names in the series and places them
in the 'Archive' worksheet. These are then placed at the foot of the graph in a
legend for reference.





I've had another go at this and all references get changed until the code gets to a
<blank series. I have 16 different inputs in my series. If I am gathering data
for an event with 5 inputs, the rest appear as <blank series (6-16).

If I save the document, re-open it and then use your string conververter, quite
naturally, only the first 5 will get converted, as they are the only inputs with
labels and the rest appear as <blank series when the document was saved.

If I then choose an event with 10 labels, naturally I get 10 labels, but only the
first 5 get converted.

It's a pity the code will not recognise <blank series and convert the data.

--


--