Hi all-

I am using the code below to generate a list of unique values from a large
worksheet; those unique values will then feed an autofilter so I can grab
each chunk of data for processing individually.

p=58751 'last row that contains data
Sheet2.Range("B1:B" & p).AdvancedFilter Action:=xlFilterCopy,
CopyToRange:=Sheet1.Range("D1"), Unique:=True

I've used similar code (different ranges) to generate unique lists in other
projects.

However, in this case I'm getting a 1004 error: "The extract range has a
missing or illegal field name."

Sheet2 cell B1 contains "displayname" and all the values underneath appear
to be regular strings (I didn't see any error values or anything like that-
this is a dump of our IT network bandwidth monitoring software).

Any suggestions?

Thanks,
Keith