The information in this article applies to:
SYMPTOMSWhen you record a Visual Basic for applications macro that adds a sheet template to a Microsoft Excel version 7.0 workbook, you will get a line of code similar to the following:
When you run this code, you receive the following error message:
CAUSEThe value for the Type argument must be a Microsoft Excel sheet constant. The sheet constants are as follows: xlWorksheet WORKAROUND
To work around this problem, use the following steps:
STATUSMicrosoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. Additional query words:
Keywords : kbprg xlwin |
Last Reviewed: October 25, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |