Click to Rate and Give Feedback
MSDN
MSDN Library
Office Development
Office 2003
IRange Interface
IRange Methods
 AdvancedFilter Method
Collapse All/Expand All Collapse All
Other versions are also available for the following:
Excel Primary Interop Assembly Reference 
IRange.AdvancedFilter Method 
This method supports the .NET Framework infrastructure and is not intended to be used directly from your code.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

Visual Basic
Dim <span id="parameterToolTip" class="tip" tabindex="0">Action</span> As XlFilterAction
Dim <span id="parameterToolTip" class="tip" tabindex="0">CriteriaRange</span> As Object
Dim <span id="parameterToolTip" class="tip" tabindex="0">CopyToRange</span> As Object
Dim <span id="parameterToolTip" class="tip" tabindex="0">Unique</span> As Object
Dim returnValue As Object
Dim iRange1 As IRange
returnValue = iRange1.AdvancedFilter(<span id="parameterToolTip" class="tip" tabindex="0">Action</span>, <span id="parameterToolTip" class="tip" tabindex="0">CriteriaRange</span>, <span id="parameterToolTip" class="tip" tabindex="0">CopyToRange</span>, <span id="parameterToolTip" class="tip" tabindex="0">Unique</span>)
Visual Basic
Function AdvancedFilter( _
	<InAttribute()> ByVal Action As XlFilterAction, _
	<InAttribute()> Optional ByVal CriteriaRange As Object, _
	<InAttribute()> Optional ByVal CopyToRange As Object, _
	<InAttribute()> Optional ByVal Unique As Object _
) As Object
C#
object AdvancedFilter(
	[In] XlFilterAction Action, 
	[In, Optional] object CriteriaRange, 
	[In, Optional] object CopyToRange, 
	[In, Optional] object Unique
);
C++
public: Object^ AdvancedFilter(
	XlFilterAction^ Action, 
	Object^ CriteriaRange, 
	Object^ CopyToRange, 
	Object^ Unique
);
J#
public System.Object AdvancedFilter(
	/*in*/XlFilterAction Action, 
	/*in*/System.Object CriteriaRange, 
	/*in*/System.Object CopyToRange, 
	/*in*/System.Object Unique
);
JScript
function AdvancedFilter(
	 Action : XlFilterAction, 
	 CriteriaRange : Object, 
	 CopyToRange : Object, 
	 Unique : Object
) : Object;

Parameters

Action

This parameter is intended for internal use only.

CriteriaRange

This parameter is intended for internal use only.

CopyToRange

This parameter is intended for internal use only.

Unique

This parameter is intended for internal use only.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker