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

Sumanth Suri wrote:
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)

The VBA help seems to assume you have recorded a macro using
"Data | Filter | Advanced filter"

The VBA help makes a lot more sense if you read it in conjunction with
the normal Excel help (search for "Advanced filter")

--
Steve Garman