XL2002: Run-Time Error 1004 When You Use the Lookup Wizard (277582)


The information in this article applies to:

  • Microsoft Excel 2002
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.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:4/14/2001
Keywords:kbbug kberrmsg KB277582
©2002 Microsoft Corporation. All rights reserved.