View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dan Thompson Dan Thompson is offline
external usenet poster
 
Posts: 125
Default How Can I return the XValues of the Series collection object ?

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