View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matthew Norman Matthew Norman is offline
external usenet poster
 
Posts: 3
Default Programmatically retrieving constants

Hi,

I want to loop through all the series on my chart and change the line
style to possibilities...

the allowed constants a
XlContinuous
XlDash
xlDashDot
xlDot
etc

xlContinuous has a value of 1, xlDash has a value of -4115 etc...

Is there any way of looping through the allowed values, and therefore
assigning the "next" constant to the dataseries being processed???