IIRC, I've had to pull out the formula information and parse out the XValues.

"Dan Thompson" wrote:

Hi there I am wondering if someone can tell me how I can return the XValues
of the Sieriescollection object. But I want them to be returned in $A1:$A10
style not R1C1 style. just need to return them to a string variable like

Somthing like

MyString = Activechart.Seriescollection(1).XValues

I have tried this and it doesn't work.

Any Ideas ??

Dan Thompson