>Hi Cetin,
>
>Thank you for the response, but I don't understand the benefit of this.
>Our application doesn't need to update the data in the sheet, it's a sort of snapshot. Therefor I feel I should be able to use a fixed hardcoded range for my SeriesCollection.
>And it's all just fine, unless the selection of the data from the datasheet is smaller that 3 rows. In that case Excel decides that C5:Fx should be D5:Fx.
>Furthermore I'm lazy ;) So if the data is correct on my datasheet and I tell Excel which range it should pick up from the data sheet it should do just that.
>
>In general I think that either generating the range (as is done in your code) or hardcoding the range doesn't resolve this (I still have to try your code)
>
>I'll get back on this, but I think it's a bug in the automation.
Sorry then I don't understand your problem.
Cetin