Excel Client:GetFilter

From CoPlanner 11
Jump to navigationJump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Function

GetFilter(BlattName, FilterName)

Diese Function provides a filter formula of the specified filter in the filter bar.

Parameter Description
BlattName Name of the working sheet, on which the filter is located.
FilterName Name of the filter, which is selcted

Example

GetFilter('Ad-Hoc Bericht';"Company") returns the formula "Company:=Bike GmbH, because "Bike GmbH" was selected in the filter