SourceData of a chart

[black_sun]

Hi to all,
I have a problem which raise this morming.
Till this morming the vba code woked without problems... I didn't
change anything.
This is the code:

Static area As String

area = "I15:K15,M1515," & "I" & intRigaEnd & ":K" & intRigaEnd &
",M" & intRigaEnd & "" & intRigaEnd

ActiveChart.SetSourceData Source:=Sheets(strFoglio).Range(area),
PlotBy:=xlRows

I don't know why it doesn't work anymore

Thanks in advance to whom will help me.

Bye Denis

 

[JLGWhiz]

What error message do you get?

 

[black_sun]

Hi,

Error 1004.

It's a generic error


Denis


JLGWhiz ha scritto:

 

[Jon Peltier]

What's the value of intRigaEnd? What is the value of area? Does this line
work:

Sheets(strFoglio).Range(area).Select

- Jon