Hi romperstomper,

Thanks for your reply.

Let me put some more context.
I am trying to pass the data from the database to a chart objects chart series.
But in a previous post of mine(different thread), I got feedback that trying to pass an
array you will reach a limitation. So passing a range object does not impose that limitation.

But I don't want the data to appear on the excel sheet. I guess I could clear the area afterwards, but I am just trying to find the most efficient way of doing this.

Sincerely,

Paluee