SourceData of a chart
 

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,M15:P15," & "I" & intRigaEnd & ":K" & intRigaEnd &
",M" & intRigaEnd & ":P" & 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

SourceData of a chart
 

What error message do you get?

" wrote:

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,M15:P15," & "I" & intRigaEnd & ":K" & intRigaEnd &
",M" & intRigaEnd & ":P" & 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

SourceData of a chart
 

Hi,

Error 1004.

It's a generic error :(


Denis


JLGWhiz ha scritto:

What error message do you get?

" wrote:

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,M15:P15," & "I" & intRigaEnd & ":K" & intRigaEnd &
",M" & intRigaEnd & ":P" & 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

SourceData of a chart
 

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

Sheets(strFoglio).Range(area).Select

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


wrote in message
...
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,M15:P15," & "I" & intRigaEnd & ":K" & intRigaEnd &
",M" & intRigaEnd & ":P" & 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