Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
advanced filter criteria "begins with" and "does not begin with" | Excel Worksheet Functions | |||
Using advanced filter to search for criteria in a list | Excel Discussion (Misc queries) | |||
Advanced Filter using Date represented as text | Excel Worksheet Functions | |||
Advanced Filter: No Filter | Excel Discussion (Misc queries) | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |