ExcelBanter - VBA - chart reference error

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

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

- - VBA - chart reference error (https://www.excelbanter.com/excel-programming/294226-vba-chart-reference-error.html)

yusoon

VBA - chart reference error

What's wrong with this code:

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

It gives me run-time error '438' object doesn't support this propert
or method

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

All times are GMT +1. The time now is 01:29 PM.