type mismatch with chart data load

**shadowphile** · 02-20-2010, 04:51 AM

Far as I can tell this approach is almost exactly the same as a previous project that had no problem! I can't figure out why I get a 'Type Mismatch' error when the chart tries to load.
(I know there are other ways, but I'd rather figure out why this is broken

thanks!

Code:

    'grab I vs V data
    Worksheets(2).Activate
    Set badd = Range(Cells(step2begin, 7), Cells(step2end, 7))
    Set blob = Union(badd, Range(Cells(step2begin, 8), Cells(step2end, 8)))
    Worksheets(3).ChartObjects(1).Chart.SetSourceData Source:=blob, PlotBy:=xlColumns

**Andy Pope** · 02-21-2010, 08:15 AM

Which line errors?
What are the values of your variables when it errors?

Can you post example

**shadowphile** · 02-21-2010, 07:44 PM

Hi Andy.
It faults on the last line where I try to set the source data for the chart. step2begin is about 11, step2end is about 1000. I did a select method with the blob range and it selects a perfectly valid block of data, ie if I preselect the same block and insert an XY chart, the data plots ok by default.