With statement help
 

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

With statement help
 

Hi

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

Regards,
Per

On 29 Okt., 04:19, Brad wrote:
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

With statement help
 

a = 16 in this case

"Per Jessen" wrote:

Hi

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

Regards,
Per

On 29 Okt., 04:19, Brad wrote:
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