I'm trying to use Advancedfilter to copy unique values from a list on one
sheet and paste to another sheet. The list being copied is part of an
external data range. The code for advancedfilter runs fine. I can run
multiple times without error.

Here's the problem:
After refreshing the external data range (data retrieved from web service
API) the advancedfilter code generates a run time error 1004 and says "The
extract range has a missing or illegal field name". The extract range is a
range within the recently refreshed external data range. I am stumped.
Is there some way I should be resetting advancedfilter or something?
Anyone know why the extract range is being viewed differently after it's
refreshed?

any suggestions would be most appreciated...

--
D.Farns

I think I'm all set with this. Evidently I was simply missing the so called
"optional" extract range heading. Adding the list's column heading to the
1st cell of the destination range seemed to do the trick.


--
D.Farns


"D.Farns" wrote:

I'm trying to use Advancedfilter to copy unique values from a list on one
sheet and paste to another sheet. The list being copied is part of an
external data range. The code for advancedfilter runs fine. I can run
multiple times without error.

Here's the problem:
After refreshing the external data range (data retrieved from web service
API) the advancedfilter code generates a run time error 1004 and says "The
extract range has a missing or illegal field name". The extract range is a
range within the recently refreshed external data range. I am stumped.
Is there some way I should be resetting advancedfilter or something?
Anyone know why the extract range is being viewed differently after it's
refreshed?

any suggestions would be most appreciated...

--
D.Farns