Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.lang.visual.basic    |    MS Visual Basic discussions, NOT dot-net    |    10,840 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 8,922 of 10,840    |
|    Kevin Long to All    |
|    help with VB in excel    |
|    30 Oct 04 15:54:08    |
      From: supermax120@hotmail.com              Hi everybody. I was wondering if somebody out there could tell me what is       wrong with this code? I'm trying to plot a chart in excel using VB. For       this example, the value of the Index variable is 150, but it could be       anything because it is calculated earlier in the code. I can't see anything       wrong with the code myself, but it seems not to like it. Any help would be       appreciated.              Kevin                            Index = 150              Charts.Add        ActiveChart.ChartType = xlXYScatterSmooth        ActiveChart.SeriesCollection.NewSeries               ActiveChart.SeriesCollection(1).XValues = Range(Cells(8, 1), Cells(Index       + 8, 1))        ActiveChart.SeriesCollection(1).Values = Range(Cells(8, 2).Value,       Cells(Index + 8, 2))              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca