K
ker_01
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
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