Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic sourcedata when copying chart within sheet | Charts and Charting in Excel | |||
Excel/chart/sourcedata - should let me set the left or right axis | Charts and Charting in Excel | |||
SourceData for graph | Excel Programming | |||
Read SourceData from Chart | Excel Programming | |||
Setting up a SourceData:= in VB | Excel Programming |