missing or ill egal extract range advanced filter
 

I am trying to use the Advanced Filter in a macro routine. If I include all
of the fields from the list, the macro works with my Copy to location, A1:K1.
If I change my Copy to location to exclude irrelevant columns, I change the
range to A1:G1.
Every time I do this, I get an error messge:
"The extract range has a missing or illegal field name."
Since the filter runs fine, if I include all the field names, I assume I
must have one missing.
I'm copying and pasting the values, so the Copy to field headings match the
list's field headings.

Here are the criteria, if that could have anything to do with it. Two
conditions on one column and one condition to compare two columns.
Course,Course,(No Header);
<Room Rentals,<Career
Days,=OR(Source!J2<"",AND(Source!K2<"",Source!K2 <"Consumer"))

Thanks,

--
tj

Does a heading get pasted into each cell in the range A1:G1?
If you're working with multiple sheets, are all the ranges fully qualified?

tjtjjtjt wrote:
I am trying to use the Advanced Filter in a macro routine. If I include all
of the fields from the list, the macro works with my Copy to location, A1:K1.
If I change my Copy to location to exclude irrelevant columns, I change the
range to A1:G1.
Every time I do this, I get an error messge:
"The extract range has a missing or illegal field name."
Since the filter runs fine, if I include all the field names, I assume I
must have one missing.
I'm copying and pasting the values, so the Copy to field headings match the
list's field headings.

Here are the criteria, if that could have anything to do with it. Two
conditions on one column and one condition to compare two columns.
Course,Course,(No Header);
<Room Rentals,<Career
Days,=OR(Source!J2<"",AND(Source!K2<"",Source!K2 <"Consumer"))

Thanks,



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

As far as I could tell, I did have the ranges fully qualified. I'm not
entirely why the code was't working. The good news is that going back to look
after I received your reply, I tinkered a bit, and it's working now.
Thanks And, thank you for the great step by step on the Advanced Filter.
Until recently, I never needed this feature very often. Now I use it daily.
The example formula criteria on your site have helped me immensely.
--
tj


"Debra Dalgleish" wrote:

Does a heading get pasted into each cell in the range A1:G1?
If you're working with multiple sheets, are all the ranges fully qualified?

tjtjjtjt wrote:
I am trying to use the Advanced Filter in a macro routine. If I include all
of the fields from the list, the macro works with my Copy to location, A1:K1.
If I change my Copy to location to exclude irrelevant columns, I change the
range to A1:G1.
Every time I do this, I get an error messge:
"The extract range has a missing or illegal field name."
Since the filter runs fine, if I include all the field names, I assume I
must have one missing.
I'm copying and pasting the values, so the Copy to field headings match the
list's field headings.

Here are the criteria, if that could have anything to do with it. Two
conditions on one column and one condition to compare two columns.
Course,Course,(No Header);
<Room Rentals,<Career
Days,=OR(Source!J2<"",AND(Source!K2<"",Source!K2 <"Consumer"))

Thanks,



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks for letting me know that you got it working, and I'm glad to hear
that the information on my web site has helped you.

tjtjjtjt wrote:
As far as I could tell, I did have the ranges fully qualified. I'm not
entirely why the code was't working. The good news is that going back to look
after I received your reply, I tinkered a bit, and it's working now.
Thanks And, thank you for the great step by step on the Advanced Filter.
Until recently, I never needed this feature very often. Now I use it daily.
The example formula criteria on your site have helped me immensely.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html