Unable to set the Values property of the Series class

[sunger]

I have a really ridiculous error that seems to have happened to a number of people in the wide world, but I have been unable to find a resolution.

I used the macro recorder in Excel to produce code which would accomplish the following:

Select a Chart
Edit Source Data
Update the y values in the first series to D$6:$D$35 of the first sheet.

Even tho I used the Macro Recorder to do this, I still get the error:

1004: Unable to set the Values property of the Series class

Here's the code I recorded:

Sub blnset()

ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.ChartArea.Select
ActiveChart.SeriesCollection(1).Values = "=BLN!R6C4:R35C4"
ActiveWindow.Visible = False
Windows("Scutellaria QC.xls").Activate
ActiveSheet.ChartObjects("Chart 2").Activate
ActiveChart.ChartArea.Select
ActiveChart.SeriesCollection(1).Values = "=BLN!R6C5:R35C5"

End Sub

If anyone out there can tell me why Microsoft sucks soooooo bad..... Er, can tell me how to fix this particular bug in MS excel, I'd really appreciate it.

-S