Advanced Filter method out of range

[dshafique]

Hi guys, Im trying to pull out unique values from a column of a table and trying to paste it in a table of a different sheet.
before I just copied the whole column and used remove duplicates, but that was taking a long time since there are a couple hundred thousand lines.
then I tried the following:

    Range("KPI[[Accountable LTO]:[Accountable LTO]]").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range("lTable[Name]"), Unique:=True

and I get an error saying the advanced filter method is out of range, any idea why?

thanks for the help!