Help with AdvancedFilter method

  • Thread starter Thread starter Sumanth Suri
  • Start date Start date
S

Sumanth Suri

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 said:
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)
Click to expand...

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")
 
Back
Top