The information in this article applies to:
SYMPTOMSThe CopyFromRecordset method should fail if you call it in a user-defined worksheet function, but the CopyFromRecordset allows a user-defined worksheet function to place information in a worksheet. This can cause Microsoft Excel to go into an infinite recalculation loop. RESOLUTIONThe CopyFromRecordset method is not supported for use in a user-defined worksheet function, and should not be used. STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. MORE INFORMATION
A user-defined worksheet function is a Function procedure designed to be
called from a formula in a worksheet.
CopyFromRecordset Additional query words:
Keywords : |
Last Reviewed: October 22, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |