Hi there,

Q1:
If one has data in a database, and gets the data via ADO, is there an easy way to transfer the data to a Range object. Is there some kind VBA function that can do this.

Q2:
Or does one have to pass an ADO recordset to a VBA arrray, and then pass the array to the range object.

If this is the case, is there a VBA function to easily copy data from an array to Range object, without having to do lots of looping?

Sincerely,

Paluee