Setting the range in a chart using VB

  • Thread starter Thread starter Torben Laursen
  • Start date Start date
T

Torben Laursen

Hi
My VB code calls a C++ dll and gets a Variant array with double back.
The number of points in the array changes every time and I want a chart to
display them.
Can anyone give me any hint as to how to feed the right range into a chart
using VB

Thanks Torben
 
This is something my I guy came up with

Sub Update_Chart(

Dim stRange As String, endrow As Intege

endrow = Range("a1").End(xlDown).ro

stRange = "a1:b" & endro

ActiveSheet.ChartObjects("Chart 1").Activat
ActiveChart.SetSourceData Source:=Range(stRange), PlotBy
:=xlColumn

Range("a1").Selec
End Su
 
Back
Top