Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
I'm a bit confused here. If I run the command "msgbox ActiveChart.Name" I get back "Sheet1 Chart 3". Yet, if I run the command "Charts(3).SetSourceData..." I get a "subscript out of range" error. This is true if I try 1, 2, 3, 4, 5, and so on. However, if I run "ActiveChart.SetSourceData..." it works, thus I know the issue is with the "Charts(3)" portion of the line. What am I doing wrong? Thanks! Trip |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
defined names and setsourcedata | Charts and Charting in Excel | |||
setSourcedata | Excel Programming | |||
SetSourceData for Chart | Excel Programming | |||
Activechart.SetSourceData Source??? | Excel Programming |