chamster
10-29-2007, 05:48 AM
When i try the following
Dim srs As Series
For Each srs In ac.SeriesCollection
srs.Delete
Next srs
ac.SeriesCollection.Add Source:=rng
ac.SeriesCollection.Add Source:=rng.Offset(0, 2)
i get series of lengths 23 (the first one) and 24 (the second one).
I'm fairly sure it depends on the fact that the first one only contains "---" on the whole range. For some reason, the first element is dropped. How can i get around it? Why does it happen?
Dim srs As Series
For Each srs In ac.SeriesCollection
srs.Delete
Next srs
ac.SeriesCollection.Add Source:=rng
ac.SeriesCollection.Add Source:=rng.Offset(0, 2)
i get series of lengths 23 (the first one) and 24 (the second one).
I'm fairly sure it depends on the fact that the first one only contains "---" on the whole range. For some reason, the first element is dropped. How can i get around it? Why does it happen?