ExcelBanter - VBA- SeriesCollection

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VBA- SeriesCollection (https://www.excelbanter.com/excel-programming/294544-vba-seriescollection.html)

yusoon[_3_]

VBA- SeriesCollection

This code gives me run-time error : '438' object doesn't support thi
property or method

Worksheets("sheet1").ChartObjects("Chart 1").Chart. _
SeriesCollection(1).Value = "=Sheet1!R1C1:R20C1

--
Message posted from http://www.ExcelForum.com

Klaus[_5_]

VBA- SeriesCollection

It is really simple:
Worksheets("sheet1").ChartObjects("Chart 1").Chart. _
SeriesCollection(1).Values = "=Sheet1!R1C1:R20C1"

The s at value -- values is missing

Regards
Klaus

-----Original Message-----
This code gives me run-time error : '438' object doesn't
support this
property or method

Worksheets("sheet1").ChartObjects("Chart 1").Chart. _
SeriesCollection(1).Value = "=Sheet1!R1C1:R20C1"

---
Message posted from http://www.ExcelForum.com/

.

All times are GMT +1. The time now is 03:00 PM.