ExcelBanter - Problem error when creating a chart in VBA

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

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

- - Problem error when creating a chart in VBA (https://www.excelbanter.com/excel-programming/427129-problem-error-when-creating-chart-vba.html)

Keith

Problem error when creating a chart in VBA

Hello,
What would cause the following line...
ActiveChart.SeriesCollection(1).XValues = "=Sheet1!$R4$C3:$R44$C3"
to produce an error number 1004?

Thanks
Keith

Jacob Skaria

Problem error when creating a chart in VBA

Replace the chartname in the below
Charts("Chartname").SeriesCollection(1).XValues =
Worksheets("Sheet1").Range("C3:C44")
--
If this post helps click Yes
---------------
Jacob Skaria

"keith" wrote:

Hello,
What would cause the following line...
ActiveChart.SeriesCollection(1).XValues = "=Sheet1!$R4$C3:$R44$C3"
to produce an error number 1004?

Thanks
Keith

Keith

Problem error when creating a chart in VBA

HI Jacob,
Thanks very much.
Keith

"Jacob Skaria" wrote:

Replace the chartname in the below
Charts("Chartname").SeriesCollection(1).XValues =
Worksheets("Sheet1").Range("C3:C44")
--
If this post helps click Yes
---------------
Jacob Skaria

"keith" wrote:

Hello,
What would cause the following line...
ActiveChart.SeriesCollection(1).XValues = "=Sheet1!$R4$C3:$R44$C3"
to produce an error number 1004?

Thanks
Keith

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