Hi

Based on my research, when we use the CopyFromRecordset the load the data
from the database to the cell.
e.g.
=SUM(A1:B1)
it will be recongnized as a text but not a fumular.

Based on my knowledge this is by design, because the cell have never
entered the edit mode.

246335 How To Transfer Data from an ADO Recordset to Excel with Automation
http://support.microsoft.com/?id=246335


Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.