I am debugging someone elses code and am having a hard time
understanding what AdvancedFilter does. I have read the help for
Visual Basic but all it tells me is how to call the method.
expression.AdvancedFilter(Action, CriteriaRange, CopyToRange, Unique)

What do the three different filter options,
xlFilterCopy,xlFilterAction,xlFilterInPlace do?

What is the CriteriaRange supposed to do?

What is the CopyToRange supposed to do?

What happens if i choose Unique := True or Unique:=False?


I'm a newbie to VBA so i'd appreciate all the help you could give me.

TIA