General information
Category:
COM/DCOM and OLE Automation
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only