Error Msg: Extract Range has a missing or Illegal field Name

B

bumblebee

HI,
I am trying to do an advance filter for 10 out of on
about 450 records when I hit the above error message.

I have got more than 10 rows sitting above the 450, with
one column populated with the criteria I want.
The first row (A)is copied from the header row of the 450.

Advance FIlter:
check Copy to another location
List Range: A18 : P:479
Criteria: A1:p11
Copy to: A2

did I miss something?

thanks,
Bumblebee
 
P

papou

Hi
You can't have the extract range in the same place as the criteria
Amend the "copy to" address to point to a range out of your criteria
HTH

Cordially
Pascal
 

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

Illegal Field Name 4
Run-time error '1004', The extract range has a missing or illegal 1
Advanced Filtering Extract Range Missing,etc 1
Error msg on Advanced Filter 0
Duplicate name range error when copying sheet (Excel 2010) 4
Copied sheet causing duplicate range name error (Excel 2010) 0
Advanced Filter process error msg 1
Copying a Range of Cells having data only 3

Top