software

Let's say I have the following

ActiveChart.SeriesCollection(1).XValues = quot;B2:B20quot;
ActiveChart.SeriesCollection(1).Values = quot;D220quot;

How do I go about extracting the XValues and Values so that I can display
quot;B2:B20quot; and quot;D220quot; in VBA. I've got

xval = activechart.seriescollection(1).Xvalues

xval is currently defined as a string. When I run, I get a run time error
'13' Type mismatch.

Thanks,
Barb

Thanks in advance.

Hi Barb,

Like I implied in the other discussion, the only way to do this is to
parse the SERIES formula. The link I provided to Walkenbach's code
encapsulates the work in a class module.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article gt;,says...
gt; Let's say I have the following
gt;
gt; ActiveChart.SeriesCollection(1).XValues = quot;B2:B20quot;
gt; ActiveChart.SeriesCollection(1).Values = quot;D220quot;
gt;
gt; How do I go about extracting the XValues and Values so that I can display
gt; quot;B2:B20quot; and quot;D220quot; in VBA. I've got
gt;
gt; xval = activechart.seriescollection(1).Xvalues
gt;
gt; xval is currently defined as a string. When I run, I get a run time error
gt; '13' Type mismatch.
gt;
gt; Thanks,
gt; Barb
gt;
gt; Thanks in advance.
gt;

Thanks.
quot;Tushar Mehtaquot; gt; wrote in message om...
gt; Hi Barb,
gt;
gt; Like I implied in the other discussion, the only way to do this is to
gt; parse the SERIES formula. The link I provided to Walkenbach's code
gt; encapsulates the work in a class module.
gt;
gt; --
gt; Regards,
gt;
gt; Tushar Mehta
gt; www.tushar-mehta.com
gt; Excel, PowerPoint, and VBA add-ins, tutorials
gt; Custom MS Office productivity solutions
gt;
gt; In article gt;,
gt; says...
gt;gt; Let's say I have the following
gt;gt;
gt;gt; ActiveChart.SeriesCollection(1).XValues = quot;B2:B20quot;
gt;gt; ActiveChart.SeriesCollection(1).Values = quot;D220quot;
gt;gt;
gt;gt; How do I go about extracting the XValues and Values so that I can display
gt;gt; quot;B2:B20quot; and quot;D220quot; in VBA. I've got
gt;gt;
gt;gt; xval = activechart.seriescollection(1).Xvalues
gt;gt;
gt;gt; xval is currently defined as a string. When I run, I get a run time
gt;gt; error
gt;gt; '13' Type mismatch.
gt;gt;
gt;gt; Thanks,
gt;gt; Barb
gt;gt;
gt;gt; Thanks in advance.
gt;gt;