Run-time Error '1004'

K

Kathy

Per Microsoft website
XL2002: Run-Time Error 1004 When You Use the Lookup Wizard
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.
Last Reviewed: 4/14/2001
Keywords: kbbug kberrmsg KB277582
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time Error '1004' 1
run-time error 1004 exiting Excel 2007 2
Error 1004 on Range.Text with AutoFilter 3
Run Time error 1
Run-time error '1004' 2
Filter Error 0
"Run-time error '1004' 5
Run time Error 1004, on shared workbook 2

Top