VBA - AdvancedFilter

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

Hi
I have this piece of code in my app....

Call searchRange.AdvancedFilter(Action:=xlFilterCopy,
CopyToRange:=tempWorksheet.Cells(1, 1), Unique:=True)

It seems to duplicate the first item in cells A1 & A2. Any ideas why?

Thanks
Ben
 
Advanced filter likes to have a row of headers. I'm betting that you don't have
one--and your first two rows are the same--so excel sees the first row as
headers and the second as data.
 
Oh, OK. That's a little annoying. ;-)

Dave Peterson said:
Advanced filter likes to have a row of headers. I'm betting that you don't have
one--and your first two rows are the same--so excel sees the first row as
headers and the second as data.
Click to expand...
 
Back
Top