Article ID: 193065
Article Last Modified on 10/22/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q193065
SYMPTOMS
If you use the PasteSpecial method in Visual Basic for Applications code, you may receive an error similar to one of the following, depending on the operating system you are using:
Windows 95 and Windows 98
If you click Details, you receive an error message similar to the following:
Windows NT 4.0
-or-
Excel may stop responding.
CAUSE
This problem may occur when the following conditions are true:
- The paste area contains formulas that return #DIV/0!, #NAME?, #NULL!, #NUM!, #REF!, #N/A, or #VALUE! errors. -and-
- You use the PasteSpecial method in Visual Basic for Applications code with any of the Operation arguments of:
- Operation:=xlPasteSpecialOperationAdd
- Operation:=xlPasteSpecialOperationSubtract
- Operation:=xlPasteSpecialOperationMultiply
- Operation:=xlPasteSpecialOperationDivide
STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows.
MORE INFORMATION
The default PasteSpecial Operation argument of xlPasteSpecialOperationNone does not cause this problem.
REFERENCES
For more information about the PasteSpecial method, from the Visual Basic Editor, click the Office Assistant, type PasteSpecial, click Search, and then click to view "PasteSpecial Method (Range Object)."
NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If the Assistant is not able to answer your query, please see the following article in the Microsoft Knowledge Base:
176476 OFF: Office Assistant Not Answering Visual Basic Questions
Additional query words: XL97 ipf paste special
Keywords: kbbug kbpending KB193065