XL2002: Run-Time Error 1004 When You Use the Lookup Wizard (277582)
The information in this article applies to:
This article was previously published under Q277582 SYMPTOMS
When you use the Lookup Wizard to copy formulas and lookup parameters to a new location in a workbook, you may receive the following error message:
Run-time error '1004'
Application-defined or object-defined error
CAUSE
This behavior can occur only if the AutoFilter feature is turned on.
WORKAROUND
To work around this issue, first turn off the AutoFilter, and then run the Lookup Wizard. To do so, point to Filter on the Data menu, and then click AutoFilter.
When you have finished using the Lookup Wizard, you can turn the AutoFilter back on.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type: | Major | Last Reviewed: | 4/14/2001 |
---|
Keywords: | kbbug kberrmsg KB277582 |
---|
|