Hi there,

Hope you can help me with this one:

I would like to select only the even rows in a range to select the y values in a graph.

What should I add to my code (which takes the whole range, also the odd rows):

ActiveChart.SeriesCollection(1).Values = ActiveSheet.Range("E105:E" & ActiveSheet.Range("E140").End(xlUp).Row)
Thanks a lot!