With statement help

[Brad]

So here's what i've got. I get a Run-time error '1004': Application-defined
or object-defined error on the marked statement.


With Charts("FTCChart")
.SeriesCollection(1).Name = "=RawData!$D$1"
-> .SeriesCollection(1).Values = _
Worksheets("RawData").Range(Cells(3, 6), Cells(a, 6))
End With

Please help

 

[Per Jessen]

Hi

Check if the "a" variable holds an integer number other than 0.

Regards,
Per

 

[Brad]

a = 16 in this case

Hi

Check if the "a" variable holds an integer number other than 0.

Regards,
Per