ExcelBanter - View Single Post - if-then statement that checks for existence of series 2

If ActiveChart.SeriesCollection.Count = 1 Then
ActiveChart.SeriesCollection.NewSeries
End If

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

danz98 wrote:

This has been posted to excel.programming

I would like to code an if-then or Case statement that does something
like this:

If ActiveChart.SeriesCollection(2) doesn’t exist, Then

ActiveChart.SeriesCollection.NewSeries.Add

ActiveChart.SeriesCollection(2).XValues = "=Sheet1!R1C9:R2C9"

ActiveChart.SeriesCollection(2).Values = "=Sheet1!R1C10:R2C10"

Else

ActiveChart.SeriesCollection(2).XValues = "=Sheet1!R1C9:R2C9"

ActiveChart.SeriesCollection(2).Values = "=Sheet1!R1C10:R2C10"

The only difference is the NewSeries.Add. What do I substitute for
doesn’t exist? 0 (zero) or False?

Danz98