Needed: An efficient way of setting values in Excel using VBA 1

[popper]

I have a need to fill a very large number of Excel cells with values from a database table. When I use the Range.Cells(row,col) method I find it is very slow, requring over 30 minutes to complete the process. Does anyone know whether or not there is a faster method?

I would appreciate help on this.

Thank you

 

[CautionMP]

popper,
Have looked at [tt]CopyFromRecordset()[/tt] method of the [tt]Range[/tt] object?

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT+08:00) Singapore

 

[popper]

Thank you so much. This solution is lightening fast and solved my problem completely!