Platforms to show: All Mac Windows Linux Cross-Platform

Back to XLAutoFilterMBS class.

XLAutoFilterMBS.AddSort(columnIndex as Integer, descending as boolean) as Boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 21.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Adds the sorted column in AutoFilter by zero-based index and its sort order.

Used for multiple level sorting.
Returns false on error and true on success. Get error info with XLBookMBS.errorMessage.

XLAutoFilterMBS.Column(colId as Integer) as XLFilterColumnMBS

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 16.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns the AutoFilter column by zero-based index.

Creates it if it doesn't exist.

XLAutoFilterMBS.ColumnByIndex(colId as Integer) as XLFilterColumnMBS

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 16.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Returns the specified AutoFilter column which have a filter information by index.

XLAutoFilterMBS.Constructor   Private

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 16.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
The private constructor.

XLAutoFilterMBS.GetRef(byref rowFirst as Integer, byref rowLast as Integer, byref colFirst as Integer, byref colLast as Integer) as Boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 16.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Gets the cell range of AutoFilter with header.

Returns false if error. Get error info with XLBookMBS.errorMessage.

XLAutoFilterMBS.GetSort(byref columnIndex as Integer, byref descending as Boolean) as Boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 16.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Gets the zero-based index of sorted column in AutoFilter and its sort order.

Returns false if error. Get error info with XLBookMBS.errorMessage.

XLAutoFilterMBS.GetSortRange(byref rowFirst as Integer, byref rowLast as Integer, byref colFirst as Integer, byref colLast as Integer) as Boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 16.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Gets the whole range of data to sort.

Returns false if error. Get error info with XLBookMBS.errorMessage.

XLAutoFilterMBS.SetRef(rowFirst as Integer, rowLast as Integer, colFirst as Integer, colLast as Integer)

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 16.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Sets the cell range of AutoFilter with header.

Some examples using this method:

XLAutoFilterMBS.SetSort(columnIndex as Integer, descending as Boolean) as Boolean

Type Topic Plugin Version macOS Windows Linux iOS Targets
method XL MBS XL Plugin 16.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Sets the sorted column in AutoFilter by zero-based index and its sort order.

Returns false on error and true on success. Get error info with XLBookMBS.errorMessage.

Some examples using this method:

The items on this page are in the following plugins: MBS XL Plugin.


The biggest plugin in space...