home bbs files messages ]

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