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