ACC: Cannot Enter a Non-Named Range in Import WizardLast reviewed: May 30, 1997Article ID: Q137936 |
The information in this article applies to:
SYMPTOMSNovice: Requires knowledge of the user interface on single-user computers. When you use the Import Spreadsheet Wizard, you cannot select or enter a non-named range of cells. As a result, you must import the entire spreadsheet instead of only a selected portion.
RESOLUTIONIf you want to import a non-named range of cells, you can use the TransferSpreadsheet action in a macro or procedure. The TransferSpreadsheet action has a Range argument that you can set to a non-named range such as A3:D16.
STATUSThis behavior is by design.
MORE INFORMATION
Steps to Reproduce Behavior
REFERENCESFor more information about importing a spreadsheet, search the Help Index for "spreadsheets, importing or linking." For more information about the TransferSpreadsheet action, search the Help Index for "TransferSpreadsheet Action." |
Keywords : kbusage WzOthr
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |