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